F2 function

[jigh74]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, I'm a new mac user and I'm using microsoft office for mac, but I'm having some problems using son features that win offices have. FOr example I use F2 in win office to see what cells are in use in a formula, but I couldnt find the same function in mac office...does any one know if there is such function?... Thanks in advance of you cooperation.

 

[CyberTaz]

The F2 key isn't used for that in Mac Excel due to OS differentiation. The
Mac equivalent of 'edit in cell' is Control+U [although my personal
preference is to use the Formula Bar in the first place ].

That and most other keyboard shortcuts are defined in Excel Help.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[TheRedOak]

A different way of seeing visibly which cells are referred to is by double-clicking the cell that contains the formula. When you do this, all the referenced cells become highlighte and can then use the TAB key to toggle through each referenced cell. In order to use this technique you must go into Excel preferences and deselect "edit directly in cell".

This has always been the most efficient way for my pea-sized brain to see what is going on within the spreadsheet. Just depends how you like to work.

Bobby

 

[Bob Greenblatt]

A different way of seeing visibly which cells are referred to is by
double-clicking the cell that contains the formula. When you do this, all the
referenced cells become highlighte and can then use the TAB key to toggle
through each referenced cell. In order to use this technique you must go into
Excel preferences and deselect "edit directly in cell".

This has always been the most efficient way for my pea-sized brain to see what
is going on within the spreadsheet. Just depends how you like to work.

Bobby

This is correct ONLY when the preference Edit directly in cells is OFF. You
are correct, it is the best and most efficient way to see what is going on
which is why I NEVER use edit directly in cell.

 

[CyberTaz]

Hey Bob;

I whole-heartedly agree with you about editing directly in cells, but as for
the dbl-clk method being...

<snip>

the best and most efficient way to see what is going on

I have to disagree a little It may be the most 'convenient' way, but I
find the Auditing Toolbar's features to be better, more informative & more
efficient. Especially if dealing with links or remote references because it
enables seeing exactly what's being referred to without hopscotching you all
over the place unless you choose to go there. If only it offered the
additional features supplied on the Dark Side.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Hey Bob;

I whole-heartedly agree with you about editing directly in cells, but as for
the dbl-clk method being...

<snip>


I have to disagree a little It may be the most 'convenient' way, but I
find the Auditing Toolbar's features to be better, more informative & more
efficient. Especially if dealing with links or remote references because it
enables seeing exactly what's being referred to without hopscotching you all
over the place unless you choose to go there. If only it offered the
additional features supplied on the Dark Side.

Regards |:>)
Bob Jones
[MVP] Office:Mac

I agree with you about the auditing tool bar. However, I rarely use it and
rely instead on double clicking. It usually gets me what I'm looking for.