To copy a cell to another cell, on the Home tab in the Clipboard group, click Copy. Click the destination cell and click Paste from the Clipboard group. That's it, you have copied a cell to another cell.
When you perform the copy and paste operation, all the information in the source cell that is the cell contents, formatting, comments, formulas are pasted in the destination cell.
Besides pasting all the information into the destination cell, you can paste any only formatting or comments or values or formulas or the link to the source cell. To do this, when you perform the paste operation, you will see the Paste Options button next to the copied cell. Click the Paste Options button and choose the option.
Things to know:
Keyboard shortcut for copy is CTRL + C and for paste CTRL + V.
Apr 12, 2011
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment