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

Cybersecurity threats proliferating for midsize and smaller businesses

This report details how SMBs can properly protect private information from breaches, design and implement a cybersecurity policy, and create safeguards for training and education.

QUIZ

Test yourself on these often confused words

The spelling checker on your word processing program can do only so much to flag problems. Your best insurance is to learn the troublesome words that trip up writers and use them correctly by the standards of formal, written English.