cycling $ in cell refs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Good guess! I did have a new logitech keyboard and it had the function keys
remapped. Turning that off solved the problem.
 
Back
Top