If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
F4 no longer automatically creates absolute reference
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? |
#2
|
|||
|
|||
F4 no longer automatically creates absolute reference
Did you go into edit mode first (either hit F2 or click on the formula bar with
A1 selected)? molla wrote: 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? -- Dave Peterson |
#3
|
|||
|
|||
F4 no longer automatically creates absolute reference
Do you have an F-Lock keyboard?
Change state and see if F4 is enabled. Gord Dibben MS Excel MVP On Fri, 4 Jun 2010 12:46:18 -0700, molla wrote: 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? |
Thread Tools | |
Display Modes | |
|
|