F4 no longer automatically creates absolute reference

  • Thread starter Thread starter molla
  • Start date Start date
M

molla

I select the text of a cell name (A1, for example), hit F4, an nothing
happens. I have to go in and type my $. How do I reset F4 to work?
 
Did you go into edit mode first (either hit F2 or click on the formula bar with
A1 selected)?
 
Do you have an F-Lock keyboard?

Change state and see if F4 is enabled.


Gord Dibben MS Excel MVP
 
Back
Top