Cutting, Copying, and Pasting Cell Values
After you’ve entered values into one or more cells, you can copy the values and paste them into another cell, remove the values from the cells and paste them elsewhere, or just cut the values and leave them on the clipboard. Excel 2007 lets you control how the pasted values appear in your worksheet.
When you do paste data you’ve cut or copied from a cell, Excel displays an option button asking how you want to format the data you’re pasting. You can choose to have the data retain its original formatting, adopt the formatting of the cell in which you’re pasting the data, or paste the data without formatting.
Cut a Cell Value
Select the cells you want to cut.
Click the Home tab.
In the Clipboard group, click ...
Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
