However, thanks to David Ringstrom at AccountingWEB (serving an industry that spends a LOT of time with spreadsheets), I just learned that the latest update to Excel for Office 365 now includes what he terms “persistent clipboard.”
I tested it out myself, and I’m not sure that’s the term I’d use for it. What’s interesting about this new feature is that when you copy the cell, it doesn’t put a static version of the contents into the clipboard for you to paste. Instead, each time you paste again, it uses whatever the current contents of that cell is.
You can see this behavior in action in the video below. Note that I only used the Copy command (CTRL + C) after entering the initial text. After that, I only used the Paste command (CTRL + V).
If you just want to paste the value of the cell, you can do that from the Paste dropdown menu in the top ribbon.
When you want to stop the cell from being copied further, use the ESC key.
Do you use Excel a lot? Will this change help you? Let us know in the comments below!
You may also be interested in: