Move or copy the contents of Excel 2007 cells

You can move or copy an entire range of cells or its contents by using the Cut, copy, and Paste commands in Microsoft Office Excel. You can also copy specific contents or properties of a cell. For example, you can copy the result value of a formula without copying the formula itself, or you can copy only the formula.

Note Excel displays a dynamically moving border around cells that have been cut or copied. To cancel the border that you move, press ESC.

Move or copy an entire range of cells

When you move or copy a cell, Excel moves or copies the entire cell, including the formula and its resulting values, cell formatting, and annotations.

1, please select the cells you want to move or copy.

How to select a cell or range

Select	Operation
A cell	Click the cell or press the arrow keys to move to the cell.
Cell range	Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while pressing the arrow keys to extend the selection. You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.
Larger range of cells	Click the first cell in the range, and then hold down Shift while you click the last cell in the range. You can use the scrolling feature to display the last cell.
All cells in a worksheet	Click the Select All button. To select the entire worksheet, you can also press CTRL + A. Note If the worksheet contains data, press CTRL + A to select the current range. Press CTRL + A for one second to select the entire worksheet.
nonadjacent cells or ranges of cells	Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges. You can also select the first cell or range of cells, and then press Shift+f8 to add another nonadjacent cell or range to the selected range. To stop adding cells or ranges to the selected range, press Shift+f8 again. Note You cannot deselect a cell or range of cells in nonadjacent selections without canceling the entire selection.
Whole row or whole column	Click the row or column heading. Row headers Column headings You can also select a cell in a row or column by selecting the first cell, and then pressing the ctrl+shift+ arrow key (right ARROW or LEFT arrow for the row, or up ARROW or DOWN arrow for the column). Note If the row or column contains data, press the ctrl+shift+ arrow key to select the portion of the row or column before the last cell that has been used. Press the ctrl+shift+ arrow key for one second to select an entire row or column.
Adjacent rows or columns	Drag the mouse between the row or column headings. Either select the first row or column, and then hold down Shift while you select the last row or column.
nonadjacent rows or Columns	Click the row or column heading for the first row in the selection, and then hold down CTRL while you click the column headings for the row headings or other columns that you want to add to the other rows in the selected range.
The first or last cell in a row or column	Select a cell in the row or column, and then press CTRL + the ARROW keys (for rows, use the right arrow or left arrow; Use the UP or DOWN ARROW keys for columns).
The first or last cell in a worksheet or Microsoft Office Excel table	Press Ctrl+home to select the first cell in the worksheet or Excel list. Press Ctrl+end to select the last cell in the worksheet or Excel list that contains data or formatting.
Range of cells before the last cell in the worksheet (lower-right corner)	Select the first cell, and then press Ctrl+shift+end to extend the selected range to the most-used cell in the worksheet (lower-right corner).
Range of cells to the beginning of the worksheet	Select the first cell, and then press Ctrl+shift+home to extend the cell selection to the beginning of the worksheet.