Excel F2??

Joined
Oct 13, 2005
Messages
31
Reaction score
0
Points
6
Hi,

In Excel for windows you press F2 over a cel and you can see the fotmula that is written inside....

Example:

Cell A19: 70
Cell A20: 30
Cell A21: 100 if you press F2 --> =A19+A20

Im no t able to do it in my Excel for mac... I have to do double click, after doing it many times I would really like ti have the F2 functionality.

Thanks

Carlos
 
Joined
May 17, 2005
Messages
151
Reaction score
6
Points
18
Location
Bristow, VA
Your Mac's Specs
2.8Ghz MBP, 4GB RAM, 320 GB 7200RPM HD
Carlos,

CTRL+` will toggle between values and formulas.

BTW the ` is NOT the apostrophe (I believe it is an accent). It is located on the same key as the ~ just underneath the ESC key (on my Powerbook).
 
OP
C
Joined
Oct 13, 2005
Messages
31
Reaction score
0
Points
6
Thanks, Ctrl + U also works.... do you know if it can be set up to work with F2?
 
Joined
May 17, 2005
Messages
151
Reaction score
6
Points
18
Location
Bristow, VA
Your Mac's Specs
2.8Ghz MBP, 4GB RAM, 320 GB 7200RPM HD
Uhhhh, yeah. Set it up in Excel Keyboard shortcuts. You can locate that in Excel HELP.
 
OP
C
Joined
Oct 13, 2005
Messages
31
Reaction score
0
Points
6
I looked for it in the key board customization window but the function is not there to asign to any key....
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top