"F2" - formula look up

[Gecko]

Hi,

I'm unable to use the F2 key anymore to look up which cells are used in a
formula, but when I go into the 'formula cell', I can see the colored cells.

Any idea how I can have the F2 key fixed ?

Thanks !

 

[Niek Otten]

You probably have checked Tools>Options, Edit tab, Edit directly in cell. Uncheck it to get F2 editing on the formula bar back.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I'm unable to use the F2 key anymore to look up which cells are used in a
| formula, but when I go into the 'formula cell', I can see the colored cells.
|
| Any idea how I can have the F2 key fixed ?
|
| Thanks !
|

 

[RagDyeR]

In XL02 Niek,
With *either* option chosen, the cells are highlighted.

I guess primarily because the <F2> key is used to start *editing*.

On the other hand, if one would want to just select the cells referenced in
the formula, you could click in the formula cell and try:

<Ctrl> < [ >


--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

You probably have checked Tools>Options, Edit tab, Edit directly in cell.
Uncheck it to get F2 editing on the formula bar back.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I'm unable to use the F2 key anymore to look up which cells are used in a
| formula, but when I go into the 'formula cell', I can see the colored
cells.
|
| Any idea how I can have the F2 key fixed ?
|
| Thanks !
|