Select the cells you want to cut, and click the Cut button. These cells now display an active selection border.
Click in the worksheet where you want to paste the cut data, and click the Paste button.
The cut cells appear in the new location. Select the cells you want to copy and click the Copy button. The cells display an active selection border.
INTRODUCTION
You can save the time and trouble of retyping duplicate information in a worksheet by cutting or copying cell text and data and pasting it. In addition to the cut, copy, and paste commands, use the Office Clipboard task pane to work with multiple items known as scraps. For example, if you need to copy two different selections of data from the beginning of a worksheet to two different locations toward the end of a worksheet, you can use the Clipboard to perform the procedure in fewer steps than if you were to copy and paste each separately.
TIP
Cutting Versus Copying
When you want to move (rather than copy) data from its current location to a new location, click the Cut button on the Standard toolbar. The Cut option removes the selected value from the old location.
Click in the worksheet where you want to paste the copied data, and click the Paste button.
The copied text is pasted in the new location. Unless it's displayed, open the Edit menu and select Office Clipboard.
The copied data displays on the Clipboard. Additional cut or copied items will display on the Clipboard; click each "scrap" to paste them.
Click the Close (x) button on the Clipboard task pane when finished.
TIP
Using the Paste Button
Use the Copy or Cut and Paste buttons on the Standard toolbar to perform a single cut/paste or copy/paste. The Clipboard task pane appears only when you click the Copy or Cut button multiple times before clicking the Paste button.
TIP
Using the Clipboard
If you want to clear all the items copied to the Clipboard, click the Clear All button in the Clipboard task pane. To paste all the items saved to the Clipboard in one location, click the Paste All button in the task pane.
TIP
Pasting Formulas
If you paste cells using the Ctrl+V keyboard shortcut, you can paste cell formulas. If you paste cells with formulas from the multielement Clipboard, you paste the values, not the formulas.