| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Now what happened? | Excel Discussion (Misc queries) | |||
| what happened | Excel Worksheet Functions | |||
| Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
| setting transferred text as constant | Excel Discussion (Misc queries) | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Linear Mode
