Excel Training Tip: Copy a Formula & keep the same cell references

Published: 19 July 2018
on channel: Summit Solutions Excel Training

134

When you Copy & 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 & columns, which in most cases is exactly what we need.

Sometimes however, we simply want to copy & paste a formula & use it as a starting point for a similar formula in a new location & 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.

Watch video Excel Training Tip: Copy a Formula & keep the same cell references online, duration hours minute second in high quality that is uploaded to the channel Summit Solutions Excel Training 19 July 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 134 times and liked it 1 visitors.

11,720

318