Home > Articles

Editing Worksheets

  • Print
  • + Share This
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.

start.gif

1.gif Select the cells you want to cut and click the Cut button. These cells now display an active selection border.

2.gif Click in the worksheet where you want to paste the cut data and click the Paste button.

3.gif 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.

4.gif Click in the worksheet where you want to paste the copied data and click the Paste button.

5.gif 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.

6.gif 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.

7.gif Click the Close (x) button on the Clipboard Task pane when finished.

end.gif

  • + Share This
  • 🔖 Save To Your Account