How to Create an Excel Absolute Reference

An absolute or fixed reference to a cell address does not change when you copy a formula across or down a spreadsheet.

Follow these easy steps to create an absolute reference:

1. Create your formula
2. Click into the cell reference you want to make an absolute reference
3. Press the F4 key on your keyboard
   
   RESULT: Two $ symbols appear in the cell reference.
   You have created the absolute reference!

We offer Excel Training in Crawley and surrounding areas