VIEWING FORMULAS W/KEYBOARD SHORTCUT

[clwenergy]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I WORK WITH EXCEL 2007 AT WORK ON A PC, AND TO VIEW THE CELLS BEING PICKED UP IN A FORMULA, CAN SELECT THE CELL THAT CONTAINS THE FORMULA, HIT "F2", AND THE CELLS INCLUDED IN THE FORMULA WILL BE HIGHLIGHTED.

I HAVE NOT YET FIGURED OUT HOW TO DO THIS IN EXCEL 2008 ON MY MAC?? THE DEFAULT KEYBOARD SHORTCUT IN EXCEL 2008 FOR THE F2 KEY IS THE "CUT" FUNCTION.

DOES ANYONE KNOW WHAT THIS SHORTCUT I AM INQUIRING ABOUT IS CALLED? AND IF SO, HOW CAN I GET IT TO BE A SHORTCUT ON MY KEYBOARD?

 

[CyberTaz]

Mac Excel doesn't have default keystrokes for Trace Precedents or Trace
Dependents, but you can assign them via Tools> Customize Keyboard. See Excel
Help on the subject for complete instructions.

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

 

[Mike Middleton]

clwenergy -

Control + u

Hold down the Control key and press the u key.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[CyberTaz]

HiYa Mike -

clwenergy -

Control + u

Hold down the Control key and press the u key.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

Now why didn't he just say he wanted to "edit in the cell"? Guess I got
retinal shock from trying to decipher the all-caps

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

 

[clwenergy]

Mike - that's exactly what I needed - thank you so much!