Copying and Moving Data
Here we go over the basics of copying and moving data between cells.
Sean is aware that with the copy and move features, he does not have to type the names of the students, formulas, etc every time.
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, as well as 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, however, you can also copy only specified contents from the cells. For example, you can copy the resulting value of a formula without copying the formula itself or you can opt to copy only the formula. You can likewise 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.
