Prev: Font by way of function?
Next: Lookup Question
From: Stan on 17 Apr 2010 15:54
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?
From: "David Biddulph" groups [at] on 17 Apr 2010 16:02
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" <Stan(a)discussions.microsoft.com> wrote in message
news:831AB7D9-13FE-4EF4-B5DD-F8B9A7EDD157(a)microsoft.com...
> 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?


From: Ziggy on 18 Apr 2010 02:07
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" <S...(a)discussions.microsoft.com> wrote in message
>
> news:831AB7D9-13FE-4EF4-B5DD-F8B9A7EDD157(a)microsoft.com...
>
>
>
> > 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.
 | 
Pages: 1
Prev: Font by way of function?
Next: Lookup Question