Excel's copy and paste options are well used features that can save you a great deal of time when creating a spreadsheet.
Copy and paste allows you to copy the data, functions, or formulas from one or more cells and add them to other cells in the same worksheet, to locations in different worksheets or even to other workbooks.
Example: Using Excel's Copy and Paste Options
For help with this example see the image above.
- Type the number 101 in cell A1 and press the Enter key on the keyboard.
- Click on cell A1 to make it the active cell.
- Click on the Copy button on the Home tab.
- Cell A1 will be surrounded by the Marching Ants to show that it is the cell being copied.
- Click on cell B1 - the destination cell for the copied data.
- Click on the Paste button on the Home tab.
- The number "101" should appear in both cells A1 and B1.