Copying Formulas from a Range of Cells without Changing the Absolute or Relative References

To copy/paste Formulas from a range of cells without changing the Absolute or Relative references:
1. Select the range of cells containing the formulas and press <Ctrl+H>.
2. In the Find what box, type the = sign.
3. In the Replace with box, type the # symbol (to change the formulas to
text).
4. Click Replace All, and then click Close.
5. Copy and paste the cells to a new location.
6. Repeat steps 1 through 3, reversing the # and = signs (to change the
text to formulas).

3:09 AM | 0 comments | Read More

Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference

Avoid the nightmare of pressing <F4> multiple times when coping and pasting formulas.
To copy/paste a Formula without changing the Absolute or Relative references:

Option 1: Select a cell under the cell containing a formula and press <Ctrl+ ’>.
Option 2: Copy and paste the formula from the Formula Bar to a cell, instead of from a cell to another cell.
Example, cell C12 contains a formula:
1. Select the formula string in the Formula Bar and press <Ctrl+C> to copy it.
2. Leave the Formula Bar by clicking the Enter or Cancel icons to the left of the fx on the Formula Bar.
3. Select another cell and press <Ctrl+V>.