Microsoft Excel Now Lets You Keep Pasting Copied Cells after Unrelated Actions

I don’t use Excel much anymore, but I used it fairly often back when I was a full-time employee. And the thing I found most frustrating about it was that copy and paste didn’t work the way every other Office program worked. Back then, if I copied a cell’s contents and then took any action other than immediately pasting it in another cell, it would be removed from the clipboard and I would have to copy it again.

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

Create Different Headers in Word

Elizabeth Kricfalusi

View Comments

  • 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.

Recent Posts

T4L Monthly Update: February 2019

CES 2019, FaceTime bug, streaming the Super Bowl, Wi-Fi calling for Android phones.

4 years ago

Top Tech Stocking Stuffers

Big-ticket electronics get all the attention, but these little extras are always appreciated.

5 years ago

Four Ways to Access Control Panel in Windows 10

Microsoft is doing its darndest to hide the classic Control Panel from Windows 10 users.…

5 years ago