2. Cell References

Each cell in a worksheet has a unique 'address' that describes its position. The address is made of two parts

a) its row position, for example 1, 2, 3 and

b) its column position, for example A, B, C

This address is called the 'cell reference'.

A typical cell reference for the most top left cell in the workbook is A1 this means its sits underneath Column A and along Row 1

Cell references are used within formulas and functions, for example:

=(A3+B4)*2 

=SUM(A5:B8)

In a spreadsheet, there are two types of cell references that you will come across, they are known as ‘relative cell references’ and ‘absolute cell references’.  We will look at each of these in turn.