Copying and Moving Data

To move data:

1. Select the cell whose contents you want to move.
2. Click Cut on the Standard toolbar.
3. Click the cell where you want to place the data.
4. Click Paste on the Standard toolbar.

If the location you're moving the cell's contents to is visible on the screen, you can drag the cell. Follow these steps:

1. Select the cell.
2. Move the mouse cursor to the border (edge) or the cell. The cursor changes from a plus shape to an arrow.
3. Click and drag to the desired location.

Note: If the contents of the cell are the result of a formula, Excel transfers the formula to the new location. However, if the contents of the cell are the basis for a formula in another cell, Excel changes the formula in that cell so that your formula still functions in the same way.

To copy data:

1. Select the cell whose contents you want to copy.
2. Click Copy on the Standard toolbar.
3. Click the cell where you want to place the data.
4. Click Paste on the Standard toolbar.

If the location you're moving the cell's contents to is visible on the screen, you can drag the cell. Follow these steps:

1. Select the cell.
2. Move the mouse cursor to the border (edge) or the cell. The cursor changes from a plus shape to an arrow.
3. Press the Option key on the keyboard.
4. Click and drag to the desired location.

If you want to copy a cell's contents to other adjacent cells in the same row or column, following these steps:

1. Place the mouse cursor over the bottom-right corner of the cell, until you see a thin black plus sign (called the fill handle).
2. Click and drag down or across.

If the cell you are copying contains a formula, Excel copies the formula. For more information, see the section on Creating Simple Formulas.

If the cell contains a number, date, or time period (such as 3rd qtr), instead of copying the data, Excel assumes you want to create an ordered list. For example, if the cell contains "1," Excel creates a list, adding 2, 3, and so on, depending on how far you drag. This is a quick way to create an ordered list.

To delete data:

Select the cell and press Delete or Backspace.

To undo editing:

Click Undo on the Standard toolbar.