To turn a formula in a cell to an absolute formula, click on the cell, then
click into the formula bar near the top of the menu bars and then press F4.
Every press of F4 afterwards, changes the absolute to Row then Column then
None

"Carly Aspden" <Carly wrote in message
...
i would like to know how to make a cell in a spreadsheet absolute.