Excel > Excel 2003 Foundation > Editing a Worksheet

Cut, Copy and Paste

You can move or copy in Excel by cutting or copying the data and then pasting it to its new location. You can cut or copy a cell, range of cells or any other item such as a picture or a chart.

Cut and Paste

Cutting and pasting moves the cell content or item. When you cut a cell it is removed from its location and placed on a clipboard (a temporary storage area). It can then be pasted to another location.

  1. Select the cell(s) or item you wish to cut
  2. Click the Cut button on the Standard toolbar Cut button, or press Ctrl + X
  3. A moving dashed border like running ants appears around the cut cell(s)
  4. Select the destination cell and click the Paste button on the Standard toolbar Paste button, or press Ctrl + V. If a range of cells were cut, select the cell in the top left corner of where you wish the range to be pasted

Copy and Paste

Copying and pasting copies the cell content or item. When you copy a cell it remains in its location and is placed on a clipboard. It can then be pasted to another location.

  1. Select the cell(s) or item you wish to copy
  2. Click the Copy button on the Standard toolbar Copy button, or press Ctrl + C
  3. The running ants appears around the copied cell(s)
  4. Select the destination cell and click the Paste button on the Standard toolbar, or press Ctrl + V. If a range of cells were copied, select the cell in the top left corner of where you wish the range to be pasted

The clipboard can hold up to 24 items, so it is possible to collect and paste multiple items in Excel.

When pasting, the Paste Options Smart tag will appear. Click this button to specify how the information is to be pasted. Options can include with source or destination formatting, whether to keep the column width and whether to maintain the value and number formatting.

Paste Options smart tag

Move and copy cells using the mouse

Using the mouse is faster and more streamline than using cut, copy and paste.

  1. Select the cell(s) to move or copy
  2. Point to the border of the cell or cell range
  3. Click and drag the cell(s) to its new location. To copy the cell(s), hold down the Ctrl key whilst dragging ensuring to release the mouse button before the Ctrl key.

Dragging data to another location

If you wish to move or copy the cell(s) to a new worksheet, hold down the Alt key to enable you to switch sheets.

Follow us on

Facebook  Twitter  You Tube