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:
Four Formatting Tips for Excel
CES 2019, FaceTime bug, streaming the Super Bowl, Wi-Fi calling for Android phones.
T4L is making some changes.
Big-ticket electronics get all the attention, but these little extras are always appreciated.
When 240 characters just isn't enough...
When ten seconds just isn't enough...
Microsoft is doing its darndest to hide the classic Control Panel from Windows 10 users.…
I use it every day, if this is the reason that the copy then move and hit enter does not default to all, that it often gives me the choice of text flavors.
It is a HUGE SOURCE OF MISERY.
I'm not clear on what you're referring to about "default to all."