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

2019 State of Financial Reporting Survey

We surveyed nearly 600 finance and accounting professionals on their month-end close and reporting processes. See the results.

VIDEO

What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.