Forum Discussion
bob_beattie1510
Dec 18, 2022Copper Contributor
how do i make a cell absolute?
how do i make a cell absolute?
Riny_van_Eekelen
Dec 18, 2022Platinum Contributor
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.
bob_beattie1510
Dec 18, 2022Copper Contributor
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
Cheers, Bob