Results 1 to 5 of 5

Thread: Excel F2??

  1. #1


    Member Since
    Oct 13, 2005
    Posts
    31
    Unhappy Excel F2??
    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

  2. #2

    Erudite.Warrior's Avatar
    Member Since
    May 17, 2005
    Location
    Bristow, VA
    Posts
    151
    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).

  3. #3


    Member Since
    Oct 13, 2005
    Posts
    31
    Thanks, Ctrl + U also works.... do you know if it can be set up to work with F2?

  4. #4

    Erudite.Warrior's Avatar
    Member Since
    May 17, 2005
    Location
    Bristow, VA
    Posts
    151
    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.

  5. #5


    Member Since
    Oct 13, 2005
    Posts
    31
    I looked for it in the key board customization window but the function is not there to asign to any key....

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel for Mac and Excel for Windows
    By newbimac in forum OS X - Apps and Games
    Replies: 5
    Last Post: 09-23-2015, 02:34 PM
  2. OS X and Excel
    By samsitland in forum OS X - Operating System
    Replies: 3
    Last Post: 11-21-2014, 09:34 PM
  3. MAC excel 08 vs PC excel 07
    By gcookie in forum OS X - Apps and Games
    Replies: 2
    Last Post: 05-31-2010, 12:32 AM
  4. Excel help please
    By challenger in forum OS X - Apps and Games
    Replies: 6
    Last Post: 04-26-2010, 01:11 PM
  5. A Little Help with Excel?
    By Dodger in forum OS X - Apps and Games
    Replies: 1
    Last Post: 06-16-2009, 05:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •