ENTER A CELL REFERENCE

Prev Show Me Step-By-Step Next

Get Ready
Determine whether your reference will be absolute (the data in cell A1) or relative (the data in the cell one to the left).

Begin
To enter an absolute reference:
Type a $
Type the column letter
Example: A
Type a $
Type the row number
Example: 1
To enter a relative reference:
Type the column letter
Example: A
Type the row number
Example: 1