Thread: What happened to setting up a constant using F4?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
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?


Reply With QuoteReply With Quote