Copying Cell Data and Values
You can copy the underlying data of cells (like the formula) or the final outputted value you see displayed in a cell.
Moving and Copying Cell Data
1. Double-click the cell that contains the data you want to move or copy.
2. In the cell, select the characters to move or copy.
3. To move or copy the selection, click Cut or click Copy on the Standard toolbar
4. In the cell, click where you want to paste the characters or double-click another cell to move or copy the data.
5. Click Paste.
6. Press ENTER.
Note: When you double-click a cell or press F2 to edit a cell, the arrow keys work only within that cell. To use the arrow keys to move to another cell, first press ENTER to complete your editing changes to the active cell.
Copy Cell Values
1. These steps convert any formula in the cell to the calculated values. The existing formatting is not overwritten.
2. Select the cells you want to copy.
3. Click Copy on the Standard toolbar.
4. Select the upper-left cell of the paste area.
5. Click the arrow to the right of Paste, and click Values.