Relative Cell References in Excel Formulas

When you enter a formula into Excel, it recognises it as a pattern as opposed to numbers.

E.g. This simple addition formula is asking Excel to remember to add up the 4th cell to the left – B6, 3rd cell to the left – C6 , 2nd to the left – D6 and 1st to the left E6 relative to the cell the formula is in. The really good thing about this is, if you want the same formula anywhere else you can copy and paste it.

relative 1

You can copy and paste formulas or just drag them (grab bottom right hand corner of call and drag) into the cells you want them in. The cells the formula refers to will change to match where you have copied it to. See below, formula copied from F6 and pasted into F7. It now refers to cells in row 7.

relative 2


Want to learn about data linking? Follow this article to find out more.

Want to learn more about Font formatting? Follow this article to find out more.

To try this out and learn more like this, attend our Excel Essentials training course.