Moving data

You can move data in the current worksheet using Cut and Paste in the action bar.

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

  2. In the action bar, click Cut.

    When you select data and click Cut, the data is removed from the worksheet to a temporary storage area called the Clipboard. Each time you select data and then choose Cut, the Clipboard contents are replaced with the most recently cut data.

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

    You need to click only one cell of the destination range. This cell is treated as the top left cell of the destination and your data gets pasted there in its original size.

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

  4. In the action bar, click Paste.

    The data appears in the destination range.

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



See also
Copying data
Deleting data
Building your worksheet