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
|
|||
|
|||
What happened to setting up a constant using F4?
I used to be able to merely use F4 in a formula to keep a cell constant. Now
it seems it doesn't work. What did they change it to? |
#2
|
|||
|
|||
What happened to setting up a constant using F4?
Still the same, including in Excel 2007.
If you are in edit mode in a formula, F4 will toggle between =A2 =$A$2 =A$2 and =$A2 -- David Biddulph "Stan" wrote in message ... I used to be able to merely use F4 in a formula to keep a cell constant. Now it seems it doesn't work. What did they change it to? |
#3
|
|||
|
|||
What happened to setting up a constant using F4?
On Apr 17, 2:02*pm, "David Biddulph" groups [at] biddulph.org.uk
wrote: Still the same, including in Excel 2007. If you are in edit mode in a formula, F4 will toggle between =A2 =$A$2 =A$2 and =$A2 -- David Biddulph "Stan" wrote in message ... I used to be able to merely use F4 in a formula to keep a cell constant.. Now it seems it doesn't work. *What did they change it to?- Hide quoted text - - Show quoted text - Your Keyboard may have an "F Lock" button that needs to be toggled if F4 doesn't work. |
Thread Tools | |
Display Modes | |
|
|