Move or copy entire cells
When you move or copy a cell, Excel moves or copies the entire cell, including formulas and their resulting values, comments, and cell formats.
- Select the cells that you want to move or copy.
How to select cells
|A single cell
||Click the cell, or press the arrow keys to move to the cell.
|A range of cells
||Click the first cell of the range, and then drag to the last cell.
|A large 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 scroll to make the last cell visible.
|All cells on a worksheet
Click the Select All button.
|Nonadjacent cells or cell ranges
||Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
|More or fewer cells than the active selection
||Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell and the cell that you click becomes the new selection.
NOTE To cancel a selection of cells, click any cell on the worksheet.
- Do one of the following:
- To move cells, click Cut on the Standard toolbar, or press CTRL+X.
- To copy cells, click Copy on the Standard toolbar, or press CTRL+C.
- Select the upper-left cell of the paste area.
Tip To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.
- Click Paste on the Standard toolbar, or press CTRL+V.
- To choose specific options when you paste cells, you can click the arrow next to Paste on the Standard toolbar, and then click the option that you want.
- By default, Excel displays the Paste Options button on the worksheet to provide you with special options when you paste cells, such as Keep Source Formatting and Match Destination Formatting. If you don't want to display this button every time you paste cells, you can turn this option off. On the Tools menu, click Options. On the Edit tab, clear the Show Paste Options buttons check box.
- Excel replaces existing data in the paste area when you move cells.
- When you copy cells, cell references are automatically adjusted. When you move cells, however, cell references are not adjusted, and the contents of those cells and of any cells that point to them may be displayed as reference errors. In this case, you'll need to adjust the references manually.
- If the selected copy area includes hidden cells, Excel also copies the hidden cells. You may need to temporarily unhide cells that you don't want to include when you copy information.
If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of the copied cells.
follow this link- http://office.microsoft.com/en-us/excel-help/move-or-copy-cells-and-cell-contents-HP005201473.aspx