Moving and Copying Data

As with most Office programs, you can move the existing information around by copying or cutting it. However, when you copy data in Excel, you’ll need to have a blank area ready to receive the data, or else Excel will overwrite any existing data. You can also tell Excel to copy the contents of a cell to a group of adjacent cells.

Move Some Content

  1. Select all the cells you want to move.

  2. Move the mouse pointer over an edge of your selection until the pointer turns into a four-headed arrow.

  3. Drag the selection to a blank location. ...

Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.