cycling $ in cell refs

[rossu]

In previous versions of excel one could cycle through the various
premutations of A1, $A$1, $A1, A$1, by hitting the F4 key. That
functionality appears to have disappeared in excel 2007. Has it moved
elsewhere or is there some simple way to get it back?

 

[Niek Otten]

That still works for me. You don't happen to have a new keyboard too, for which you have to enable the function keys with an F
Lock key?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In previous versions of excel one could cycle through the various
| premutations of A1, $A$1, $A1, A$1, by hitting the F4 key. That
| functionality appears to have disappeared in excel 2007. Has it moved
| elsewhere or is there some simple way to get it back?

 

[rossu]

Good guess! I did have a new logitech keyboard and it had the function keys
remapped. Turning that off solved the problem.