- Editing Data
- Overwriting and Deleting Data
- Undoing and Redoing Changes
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Cutting, Copying, and Pasting Data
- Flipping Rows and Columns
- Moving Data
- Finding Data
- Replacing Data
- Adding and Viewing Cell Comments
- Editing and Deleting Cell Comments
- Inserting Symbols
- Tracking Changes
- Accepting or Rejecting Tracked Changes
- Checking Spelling
This chapter is from the book
This chapter is from the book
This chapter is from the book
Cutting, Copying, and Pasting Data
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.
)
)
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. These cells now display an active selection border.
)
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 the Clipboard task pane is already displayed, open the Edit menu and choose Office Clipboard.
Notice the copied data is displayed 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.
)