How to Copy and Move Data In Excel 2013 - dummies

By Bill Evans

When you’re creating a spreadsheet in Excel 2013, it’s common not to get everything in the right cells on your first try. Fortunately, moving content between cells is easy.

Here are the two methods you can use to move content:

  • Mouse method: Point at the dark outline around the selected range and then drag to the new location. If you want to copy rather than move, hold down the Ctrl key while you drag.

  • Clipboard method: Choose Home→Cut or press Ctrl+X. (If you want to copy rather than simply move, choose Home→Copy rather than Cut or press Ctrl+C.) Then click the destination cell and choose Home→Paste or press Ctrl+V.

If you’re moving or copying a multi-cell range with the Clipboard method, you can either select the same size and shape of range for the destination, or you can select a single cell, in which case the paste occurs with the selected cell in the upper-left corner.

In the following exercise, you learn to move and copy cell content by using two methods.

  1. In a file, select the range. In this example, the range A1:B6 was selected.

    To do so, click A1, hold down the left mouse button, and drag to cell B6. Then release the mouse button.

  2. Point at the border of the selection so the mouse pointer shows a four-headed arrow along with the arrow pointer.

  3. Drag the selection to C1:D6.

    An outline shows the selection while you drag the selection, and a ScreenTip shows the cell address of the destination, as shown in this figure.


  4. Click cell C1 and press Ctrl+X to cut.

    A dotted outline appears around C1.

  5. Click cell B1 and press Ctrl+V to paste.

    The text moves from C1 to B1.

  6. Select C3:D6 and then choose Home→Cut.

  7. Click cell B3 and then choose Home→Paste.


  8. Click the Save button on the Quick Access toolbar to save the changes to the workbook.