Remember the last thing copied

Sara00712

New Member
Joined
Oct 31, 2019
Messages
3
Hello ppl! I googled my problem before posting but couldn't find anything helpful so i decided to ask here.
Is there an option to remember the last thing i copied and paste it after doing several actions in between ?
For example > I have to copy some text and paste in one cell, than i change the row height, color fill some other cells, add new rows .. or whatever.. and then i want to paste the same text in another cell. In order to do that I need to go up, copy that once again so i can paste it. This takes me a lot of time, so i wonder if there's an option to just copy something once and keep that thing copied until i copy something else? :confused:
I'm using Excel 2016.

Thanks a lot :))
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

The function key F4 allows to repeat your last action ...

Hope this will help
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,339
Office Version
365
Platform
Windows
welcome to the forum

simple with VBA

1. Place in a standard module
Code:
Public CopiedText As String

Sub GetText()
    CopiedText = ActiveCell.Text
End Sub

Sub PasteText()
    ActiveCell = CopiedText
End Sub
- open VBA editor with {ALT} {F11}
- Insert Module with {ALT} I M
- paste code into the window which open up
- back to Excel with {ALT} {F11}

2. Assign shortcuts to the 2 macros
eg so that you can copy with
{CTRL} k and paste with {CTRL} q

- to assign shortcut
{ALT}{F8} \ select macro \ Options \ insert chosen letter into the box \ click OK
 

Sara00712

New Member
Joined
Oct 31, 2019
Messages
3
welcome to the forum

simple with VBA

1. Place in a standard module
Code:
Public CopiedText As String

Sub GetText()
    CopiedText = ActiveCell.Text
End Sub

Sub PasteText()
    ActiveCell = CopiedText
End Sub
- open VBA editor with {ALT} {F11}
- Insert Module with {ALT} I M
- paste code into the window which open up
- back to Excel with {ALT} {F11}

2. Assign shortcuts to the 2 macros
eg so that you can copy with
{CTRL} k and paste with {CTRL} q

- to assign shortcut
{ALT}{F8} \ select macro \ Options \ insert chosen letter into the box \ click OK

Thank you, thank you, thank you!!! It worked!! :):):)
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,339
Office Version
365
Platform
Windows
Thank you for your feedback (y)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,283
Messages
5,485,863
Members
407,522
Latest member
Tashbbb

This Week's Hot Topics

Top