Tuesday, May 21, 2013

How to Paste a Function in Excel 2003


1. Click to select the cell that you want to copy. To select multiple cells, click and drag your mouse to highlight the range or hold down the Ctrl key and click each cell you wish to copy.
2. Press Ctrl C on your keyboard to copy the cells, or click 'Edit' and then 'Copy' on the main toolbar.
3. Click in the blank cell where you want to paste the formula.
4. Right-click, then choose 'Paste Special,' or click 'Edit' and then 'Paste Special' to display the 'Paste Special' dialog box.
5. Select the 'Formulas' radio button, then click 'OK.' The formulas or functions are pasted into your spreadsheet.

Blogger news