About moving and copying data
When you copy a cell by dragging or by clicking Cut or Copy , and Paste , Microsoft Excel copies the entire cell, including formulas and their resulting values, comments, and cell formats.
If the selected copy area includes hidden cells, Excel also copies the hidden cells. If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of the copied cells.
Instead of copying entire cells, you can copy specified contents from the cells. For example, you can copy the resulting value of a formula without copying the formula itself or you can copy only the formula. You can also change what part of the cell you pasted by clicking Paste Options in the lower right corner of your pasted selection.
Note Paste Options is available only after you copy a selection, not after you cut or move a selection.