MS Excel Tip: Copy a formula & keep the same cell references

When you Copy and Paste a cell that has a formula, the cell references change relative to the formulas new location. This enables us to replicate formulas across rows and columns which in most cases is exactly what we need.

Sometimes however, we simply want to copy and paste a formula and use it as a starting point for a similar formula in a new location and keep the cell references as they are. To do that:

  1. Select the cell that has the formula you want to copy.

  2. Press F2 or double-click to enter Edit Mode.

  3. Press ctrl-A to select the whole formula.

  4. Press escape (top left on your keyboard) to exit Edit mode.

  5. Select the cell that you want to copy the formula to.

  6. Press ctrl-V to paste the formula in its new location.

If you found this Excel tip helpful, click here to learn how to edit multiple sheets at the same time.

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Archive
Search By Tags

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions