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.

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
Jul 23rd 2017 06:39

Very helpful.Thanks for sharing sarahah article with us.I love this article.

Thanks (0)
avatar
Aug 17th 2017 06:45

i am visiting first time to your blog awesome post you have written, thank for sharing
JIO Free Phone Online Booking

Thanks (0)