top of page

What are absolute and relative formulae?

When you copy and paste formulae that reference other cells within a spreadsheet, the cell references are automatically interpreted as being relative to the original formula location.

To stop the location of the referenced cell changing when it is copied elsewhere, you should insert $ signs before the column or row (or both). For example, if =$A1 was copied horizontally, the column would stay the same. If the same formula was copied vertically, the row would change.

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page