P
Pokey
For those of you who are familiar with the WinBLOWS version of EXCEL,
there is a nice little key command (F2) that allows you to see the
details of any cell along with formula references. When you're in a
cell with a formula, you simply hit the F2 key and it will highlight in
different colors each cell references for that formula. Its very handy
for checking formulas.
How can I do this in Excel for the Mac?
I know you can acomplish the same thing by double-clicking with your
mouse positioned in the cell of interest, but this is painfully
slow/cumbersome. I've looked for key commands, combinations of
keystrokes, and toolbar commands that might help me do this, but have
not been able to find anything that will accomplish this.
Happy New Year
there is a nice little key command (F2) that allows you to see the
details of any cell along with formula references. When you're in a
cell with a formula, you simply hit the F2 key and it will highlight in
different colors each cell references for that formula. Its very handy
for checking formulas.
How can I do this in Excel for the Mac?
I know you can acomplish the same thing by double-clicking with your
mouse positioned in the cell of interest, but this is painfully
slow/cumbersome. I've looked for key commands, combinations of
keystrokes, and toolbar commands that might help me do this, but have
not been able to find anything that will accomplish this.
Happy New Year