Move and copy data

Move or copy whole cells

When you copy or cut a cell and then paste it, you copy or move the entire cell, including formulas and their resulting values, and cell formats.

If the area you select to copy includes cells hidden by filtering, you copy only the visible cells. You cannot move data from a range that includes filtered rows. To move the data you must first turn off filtering.

1. Select the cells you want to move or copy.
2. Do one of the following:

   • To move the cells, click Cut .

   • To copy the cells, click Copy .

   Note   When you cut data, you can paste it only once, but if you copy data, you can paste it multiple times. If you want to paste the data in several locations, use the Copy button to copy the data.

3. Click the upper-left cell of the area where you want to paste the cells.
4. Click Paste .

Notes

• Cells that you copy or move replace any data in the area where you paste the cells.
• When you move a formula, the cell references within the formula do not change. When you copy a formula, absolute cell references do not change; however, relative cell references will change.

Move or copy characters within a cell

1. Double-click the cell with the characters you want to move or copy.
2. In the cell, select the characters you want to move or copy.
3. Do one of the following:

   • To move the characters, click Cut .

   • To copy the characters, click Copy .

4. In the cell, click where you want to paste the characters.
5. Click Paste .
6. Press ENTER.