how do i make a cell absolute?

Copper Contributor

how do i make a cell absolute?

2 Replies

@bob_beattie1510 You can make a reference to a cell absolute by including $ signs in front of either or both the column letter and row number.


For example: $A$1 or $A1 or A$1


Select a reference in a formula on the formula bar and press F4 to toggle through all options.

Thanks Riny, In my last version of excel I used to just push f4 for what I wanted. Now if I push f4 it just moves the cursor to another cell??
Cheers, Bob