What's the F2 button equivalent in Mac excel?

Discussion in 'OS X and OS X Apps' started by TrackShields, Aug 26, 2007.

Thread Status:
Not open for further replies.
  1. TrackShields

    TrackShields Member

    Joined:
    Aug 10, 2007
    Messages:
    469
    Likes Received:
    0
    Location:
    Makati
    Hi,

    Before i switched to mac i used the F2 button to modify contents of a cell in excel. the same button doesn't work for the mac version of excel. whenever i make changes in a cell, the original contents diappear first then i'd have to retype everything again... kinda tiring. Is there another shortcut button that does the same thing? are there settings that i have to modify to make it work?

    TIA
     
  2. barns

    barns Member

    Joined:
    Aug 2, 2005
    Messages:
    441
    Likes Received:
    0
    Location:
    Manila
    Ctrl-U.

    HTH :)
     
  3. hubes

    hubes Member

    Joined:
    Apr 18, 2004
    Messages:
    728
    Likes Received:
    0
    Location:
    here, there, & everywhere
    Or you can double-click on the highlighted cell to modify it's contents.
     
  4. TrackShields

    TrackShields Member

    Joined:
    Aug 10, 2007
    Messages:
    469
    Likes Received:
    0
    Location:
    Makati
    thanks for the tip guys, both work :)... still miss F2 though. :(
     
  5. kemalozturk

    kemalozturk Guest

    Are you an idiot?

    He's asking for the equivalent of F2 in Macs, and you advise him to double-click on the cell???

    Oh boy, how smart are you!

    I guess your mother had been telling you that you were a special boy, right?
     
  6. kentamayo

    kentamayo Active Member

    Joined:
    Jul 28, 2006
    Messages:
    4,335
    Likes Received:
    1
    Gender:
    Male
    Location:
    Biñan, Laguna

    [​IMG]
     
  7. ricpac

    ricpac Active Member

    Joined:
    Oct 14, 2007
    Messages:
    1,277
    Likes Received:
    0
    Location:
    Cagayan de Oro
    Right on Ken, DNFTT!
     
  8. b3nn3tt

    b3nn3tt Member

    Joined:
    Jan 15, 2008
    Messages:
    288
    Likes Received:
    0
    you can also try Shift + F3. i don't think that there is a single key equivalent in Mac.

    or you can try this out if you want:
    Entering Edit Mode with F2
     
    #8 b3nn3tt, Feb 26, 2009
    Last edited: Feb 26, 2009
  9. rafaelc378

    rafaelc378 Active Member

    Joined:
    Mar 19, 2008
    Messages:
    5,464
    Likes Received:
    2
    @kemalozturk: Please keep the discussion here on PhiliMUG civil at all times. It's your first post here on PhilMUG, did you really have to make it an overt insult at another member and their family? There are ways to point out a mistake without insulting them.

    I normally give out warnings before giving out infractions. I decided against doing so in your case, since your first impression here at PhilMUG was decidedly a negative one.

    And before you felt the need to write what you did, you did note that you were responding to a 15 month old post/thread?
     
  10. rycua

    rycua Member

    Joined:
    Jun 9, 2008
    Messages:
    552
    Likes Received:
    0
    Gender:
    Male
    Location:
    Binondo, Manila
    mac excel's shortcut seems odd isn't it? control key + u?
    isn't that supposed to "underline" the selected portion? :p

    anyway at least numbers shortcut equivalent of option key + return key isn't as peculiar! :)
     
  11. jay25

    jay25 Member

    Joined:
    Nov 29, 2008
    Messages:
    293
    Likes Received:
    18
    Thanks for this.. I'm so used to the F2 key as well and it's quite frustrating to have to double click everytime I have to edit a cell. When I use excel I like to use the keyboard as much as possible so I'm more efficient.

    @rycua: I agree. It seems that the ctrl key equivalent in windows is the command button in mac.
     
Thread Status:
Not open for further replies.

Share This Page

  • About PhilMUG

    Since the mid-1990s, PhilMUG (formerly the Philippine Macintosh Users Group) has grown to become not just the Philippines’ but one of the world’s foremost Apple user groups. Our online community brings together thousands of members from the Philippines and around the world for the latest news and discussions covering all Apple products and related hardware and software. Anyone can join PhilMUG, from newbies to experts, subject to our membership rules and guidelines.
  • Like us on Facebook

  • Buy us a beer!

    The staff works very hard to make sure that PhilMUG is running 24/7. Care to buy us a beer or help out with our hosting fees? We'd really appreciate it!

    Donate to us!