How to Deal With Excel 2016’s New Persistent Clipboard

Spreadsheets and graphs on a desk
xfgiro/istock

If you’ve used Microsoft Excel for any length of time you’ve probably realized that it has had a completely different relationship with the Windows Clipboard than any other application you may have used.

I purposely chose the words “has had” because, at long last, Microsoft Excel 2016 will no longer clear the clipboard when you happen to take any action unrelated to pasting the data. I’ll first set some background for how this feature historically worked and then show you what to expect going forward if you’re using an Office 365 subscription-based version of Microsoft Excel.

Let’s say that you select and copy a range of cells, and then notice that you wanted to bold the top row. When you select those cells and click the Bold icon, suddenly what you had copied to the clipboard is no longer there – you have to select and copy the data again.

Conversely, let’s try this in Excel 2016:

1. Select any range of cells.

2. Click the Copy command or press Ctrl-C.

3. Select a different range of cells.

4. Press Ctrl-B to make those cells bold.

5. Notice that your selection of copied cells is still valid and ready for you to paste without selecting the range again.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.

Replies

Please login or register to join the discussion.

avatar
By mfstock
Mar 7th 2018 21:55

I don't understand how this helps to "deal with the clipboard"? The title doesn't fit the content.

Thanks (0)