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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.