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.
About David Ringstrom, CPA
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.