View Single Post
  #2  
Old April 17th, 2010, 09:02 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default 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?