Dear Excel Gurus,

I remember that in creating a formula with an absolute reference, say =$B$1 +$B$2, I used to click on a cell (say B1), then hit the F4 key and it would convert B1 into $B$1. I see that the online help mentions that capability.

For some reason this no longer works. I restarted Excel and even rebooted the PC, but it still does not work.

Does Excel have some secret setting I messed up?

Thank you very much.
Studiosa