How to Automatically Use Absolute Cell Reference in Excel

1. Open Excel.
2. Click the empty box in the upper-left corner of the spreadsheet. This is the box that is to the left of column A and on top of row 1. This highlights every cell in the spreadsheet.
3. Click in the formula tab.
4. Press F4 to toggle to the absolute value reference. Since all cells are highlighted, this toggling will affect every cell in the spreadsheet.