Pasting Away Again

BY J. CARLTON COLLINS

Q: Often in Excel, I have the need to copy and paste data from one cell location to multiple cell locations as I continue to work in Excel. However, after I have copied a cell’s content, but before I am finished pasting that cell’s content, Excel loses the copied content whenever I use an Excel command from the menu, such as bolding a font. I would like to continue pasting without having to repeatedly recopy content, while using Excel menu commands before I am finished pasting. Is there a way to do this?

 

A: This solution should help. Before you copy the contents of the source cell, press the F2 key to enter edit mode. While in edit mode, use your mouse to highlight and select the contents of the cell you wish to repaste, then right-click and select Copy from the pop-up menu (or press Ctrl+C) (see screenshot below). This will copy the contents of your source cell to the Windows Clipboard where it will remain until you copy something else to the clipboard. This will allow you to continue pasting the contents of the original cell multiple times without losing the source data, even if you use the Excel menu commands.

 

 

More from the JofA:

 Find us on Facebook  |   Follow us on Twitter  |   View JofA videos

SPONSORED REPORT

Tax reform changes are now in effect

With all the recent tax law changes, this year it’s more important than ever to make sure your clients’ tax situations are squared away before year end. This report provides necessary guidance to ensure 2019 starts without a hitch.

PODCAST

Using drones to enhance audits

Hermann Sidhu, CPA, global assurance digital leader at EY, walks us through EY’s exciting new project to use drones to help audit large warehouses and outdoor inventories.