Prev: Can Excel be reset to the original settings?
Next: Conditional Formatting and Formulas
From: Stu on 22 Mar 2010 11:43
The <Ctl> <]> did not take me back to the formula cell. I am using Office
2007. Thanks in advance for any help.
Stu



"Mindy" wrote:

> Never mind. I found it.
>
> It's under Excel Options > Advanced.
> --
> Thanks.
> ~ Mindy
>
>
> "Mindy" wrote:
>
> > What about the same option in Excel 2007? I haven't been able to locate the
> > "Edit Directly in Cell" option there. Help!
> > --
> > Thanks.
> > ~ Mindy
> >
> >
> > "Ragdyer" wrote:
> >
> > > You can go to:
> > > <Tools> <Options> <Edit> tab,
> > > And *UNCHECK*
> > > "Edit Directly In Cell".
> > >
> > > Also ... you can retain the functionality of editing in the cell and still
> > > jump to reference cells by selecting the cell with the formula, and then:
> > >
> > > <Ctrl> < [ >
> > >
> > > You can then return to the formula cell with:
> > >
> > > <Ctrl> < ] >
> > > --
> > > HTH,
> > >
> > > RD
> > >
> > > ---------------------------------------------------------------------------
> > > Please keep all correspondence within the NewsGroup, so all may benefit !
> > > ---------------------------------------------------------------------------
> > >
> > > "MFINE" <MFINE(a)discussions.microsoft.com> wrote in message
> > > news:53FD0FB5-4FB9-47C4-AC2D-2D2682D2376D(a)microsoft.com...
> > > > Looking for the feature that will allow double-clicking on a cell and then
> > > > being transferred to the reference cell - think it it a Lotus
> > > > compatibility
> > > > feature.
> > > >
> > > > thanks
> > >
> > >
> > >
 | 
Pages: 1
Prev: Can Excel be reset to the original settings?
Next: Conditional Formatting and Formulas