• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 8. Editing Worksheets > Cutting, Copying, and Pasting Data

Cutting, Copying, and Pasting Data

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint