Copying data

You can copy selected data in a worksheet using the Copy and Paste commands in the action bar.

  1. Select the range containing the data you want to copy.

  2. In the action bar, click Copy.

    The data is copied to a temporary storage area called the Clipboard, leaving the original data in place. Each time you select data and then choose Copy, the Clipboard contents are replaced.

  3. Select the range where you want the copied data to appear.

    You need to select only one cell of the destination range. Your spreadsheet treats that cell as the top left cell of the destination and will paste all the data.

  4. In the action bar, click Paste.

    Caution 1-2-3 writes over any existing data in the destination range, including data in hidden columns or rows.

    The copied data appears at the location you clicked.

Note When you copy a formula, it can affect the results of the formula. For more information, see Copying a formula. and Controlling how a formula refers to data.



See also
Moving data
Deleting data
Building your worksheet