Move or Copy Cells
Here we go over how to copy data from one set of cells to another and all of the special cases it involves.
Sean now wants to copy the names of students and the marks obtained in math into another worksheet. To do this, select the cells you want to move or copy. The various options available are
|
To select |
Do this |
|
Text in a cell |
If editing in a cell is turned on, select the cell, double-click in it, and then select the text in the cell. If editing in a cell is turned off, select the cell, and then select the text in the formula bar. |
|
A single cell |
Click the cell, or press the arrow keys to move to the cell. |
|
A rangeof cells (A range is two or more cells on a sheet. Cells in a range can be adjacent or nonadjacent.) |
Click the first cell of the range, and then drag to the last cell. |
|
A large range of cells |
Click the first cell in the range, and then hold down the SHIFT key and click the last cell in the range. You can scroll to make the last cell visible. |
|
All cells on a worksheet |
Click the Select All button. |
|
Nonadjacent cells or cell ranges |
Select the first cell or range of cells, and then hold down the CTRL key and select the other cells or ranges. |
|
An entire row or column |
Click the row or column heading. |
|
Adjacent rows or columns |
Drag across the row or column headings or select the first row or column; then hold down the SHIFT key and select the last row or column. |
|
Nonadjacent rows or columns |
Select the first row or column, and then hold down the CTRL key and select the other rows or columns. |
|
More or fewer cells than the active selection |
Hold down the SHIFT key and click the last cell you want to include in the new selection. The rectangular range between the active cell.and the cell you click becomes the new selection. (The active cell is the selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.) |
|
Cancel a selection of cells |
Click any cell on the worksheet. |
After selecting the cells, do the following to
- Move cells
- Click Cut on the Standard toolbar and select the upper-left cell of the paste area.
- Copy cells
- Click Copy and select the upper-left cell of the paste area.
- Move or copy a selection to a different worksheet
- Click Cut or Copy, click the New worksheet tab, and select the upper-left cell of the paste area.
- Move or copy cells to a different workbook
- 1. Click Cut or Copy, switch to the other workbook, and select the upper-left cell of the paste area.
- 2. Click the arrow next to Paste and choose from the options on the list.
Note: Microsoft Excel replaces data in the paste area when you move cells.
Insert Moved or Copied Cells Between Existing Cells
1. Select the cells that contain the data you want to move or copy.
2. To move or copy the selection, click Cut or Copy on the Standard toolbar.
3. Select the upper-left cell of the paste area.
4. On the Insert menu, click Cut Cells or CopiedCells.
If you are moving or copying a range of cells as opposed to a row or column, click the Direction to shift the surrounding cells in the Insert Paste dialog box,.
