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

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.