Thursday, November 15, 2012

How to Copy Formulas Without Changing Cell References in Excel


1. Click the cell containing the formula that you would like to copy, then use the mouse pointer to highlight all of the text in the formula bar (the bar with 'fx' on the left side) at the top of the screen. Alternatively, press the 'F2' key to display the formula in the cell itself, then highlight it with the mouse pointer.
2. Press the 'Ctrl' and 'C' keys simultaneously to highlight the copied text.
3. Press the 'Escape' key to take Excel out of the formula editing mode.
4. Click the cell that you would like to paste the formula into.
5. Press the 'Ctrl' and 'V' keys simultaneously to paste the formula into the selected cell. Repeat steps 4 and 5 for each cell that you would like to paste the formula into.

Blogger news