Editing Records in an Excel 2007 Table
Splitting Data into Multiple Columns in Excel 2007
Transposing Data in Excel 2007

Cutting, Copying, and Pasting in Excel 2007

You can use the Cut, Copy, and Paste commands to move or copy information in an Office Excel 2007 worksheet. These commands use the Office Clipboard as a kind of electronic halfway house where the information you cut or copy remains until you decide to paste it somewhere. Because of this Clipboard arrangement, you can use these commands to move or copy information to any other worksheet open in Excel or even to other programs running in Windows (such as a Word document).

Moving a cell selection

To move a cell selection with Cut and Paste, follow these steps:

  1. Select the cell(s) you want to move.

  2. Click the Cut command button in the Clipboard group on the Home tab (the button with the scissors icon).

    As an alternative, press Ctrl+X. The program surrounds the cell selection with a marquee and displays the following message on the Status bar: Select destination and press ENTER or choose Paste

  3. Move the cell cursor to, or click the cell in the upper-left corner of, the destination range.

    When you indicate the destination range, you don’t have to select a range of blank cells that matches the shape and size of the cell selection you’re moving. Excel only needs to know the location of the cell in the upper-left corner of the destination range.

  4. Press Enter or Ctrl+V to complete the move operation.

    Alternatively, you can click the Paste button in the Clipboard group on the Home tab. The cell contents disappear from where they began and reappear in their new location.

Copying a cell selection

Copying a cell selection with the Copy and Paste commands follows a nearly identical procedure to the one you use with the Cut and Paste commands. After selecting the range to copy, you click the Copy button on the Home tab or press Ctrl+C.

An advantage to copying a selection with the Copy and Paste commands and the Clipboard is that you can paste the information multiple times. Just make sure that, instead of pressing Enter to complete the first copy operation, you click the Paste button on the Home tab in the Ribbon or press Ctrl+V. After you select the first cell of the next range where you want the selection copied, choose the Paste command again. When you make the last copy, press Enter. If you forget and choose Paste, you can remove the marquee around the original cell range by pressing the Esc key.

Right after you click the Paste button on the Home tab of the Ribbon or press Ctrl+V to paste cell entries that you copy (not cut) to the Clipboard, Excel displays a Paste Options button with its own drop-down button at the end of the pasted range. Click the button to see options that you can select to modify the paste operation. For example, you can select Formatting Only to copy only the formatting, or select Keep Source Column Widths to also copy the column widths.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Comparing Two Excel 2007 Worksheets Side by Side
Using Drag and Drop in Excel 2007
Annotating with Text Boxes in Excel 2007
Automatically Fix Typos and Add Text with Excel 2007's AutoCorrect Feature
Basic Data Editing in Excel 2007
Advertisement

Inside Dummies.com