excel.advanced.course - Absolute Reference

Hi Adenike

Thank you for your question.

You can make a cell in a formula into an absolute reference by doing the following:

When you click on a cell to put it into the formula, press the F4 key once immediately afterwards. This will insert two $ signs, one before the column letter and another between the column letter and the row number. This is now an absolute reference which means that if the formula that the cell is in is copied to another location in the spreadsheet, this cell remained fixed or locked into the formula (in other words the cell reference does not change).

I hope this helps.
Amanda