Microsoft® Office Excel® 2007 Plain & Simple

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

1. Select the cells you want to cut.

2. Click the Home tab.

3. In the Clipboard group, ...