Excel for Mac Shortcuts

Discussion in 'OS X and OS X Apps' started by cityslicker, Jun 15, 2009.

  1. cityslicker

    cityslicker New Member

    Joined:
    May 24, 2007
    Messages:
    12
    Likes Received:
    0
    Does anybody know how to do the following?

    1. Say cells are A, B, C and D. When all cells are highlighted, hitting one key (the delete button) in a PC erases data on cells A, B, C and D. On mac, it only deletes data from A. Any way we can do this also?

    2. What is the mac equivalent of the F2 function key in Excel (one-button cell edit)?

    TIA
     
  2. philpangandian

    philpangandian Active Member

    Joined:
    Feb 1, 2008
    Messages:
    3,155
    Likes Received:
    0
    Location:
    Malate, Manila
    1. fn+delete
    2. control+u
     
  3. cityslicker

    cityslicker New Member

    Joined:
    May 24, 2007
    Messages:
    12
    Likes Received:
    0
    thanks so much!
     
  4. Kenneth

    Kenneth Moderator

    Joined:
    Apr 8, 2004
    Messages:
    3,195
    Likes Received:
    3
    Anybody know the shortcut for duplicate ( copies the cell directly above it)
     
  5. h.chua

    h.chua Active Member

    Joined:
    May 14, 2006
    Messages:
    1,128
    Likes Received:
    5
    Gender:
    Male
    Location:
    Singapore
    how do you center the contents in a cell?
     
  6. imperialv

    imperialv Member

    Joined:
    Dec 11, 2006
    Messages:
    685
    Likes Received:
    0
    Location:
    Makati
    Thanks.. I was wondering about it.. :rolleyes:
     
  7. carlozesteban

    carlozesteban Member

    Joined:
    Jul 28, 2009
    Messages:
    127
    Likes Received:
    0
    Gender:
    Male
    Location:
    Caloocan City
    Haha... I was wondering the same thing! Thanks philpangandian!
     
  8. Xandman

    Xandman New Member

    Joined:
    Dec 28, 2009
    Messages:
    11
    Likes Received:
    0
    just going to share some more excel shortcuts, but before i do...you can set the shortcuts yourself. if you are using mbp you might want to remove the functions on f1-f12 so you can use them for excel.

    command+y = repeat last action

    theres no "Key" letter to doing paste special then function unlike in windows where you can do right click > s > v to paste values so I set mine to ctrl+v since cmd+v is normal paste
     
  9. Xandman

    Xandman New Member

    Joined:
    Dec 28, 2009
    Messages:
    11
    Likes Received:
    0
    got a question for mac excel users: is there a way for excel to always open documents at 125% zoom and expanded? i have a 13in mbp and its quite a hassle to always change the views everytime i edit a new excel file cause the font is so tiny.
     
  10. ijingo

    ijingo Active Member

    Joined:
    Feb 2, 2008
    Messages:
    3,279
    Likes Received:
    0
    Location:
    Quezon City
    To make a default view or normal view not the page layout view, go to Excel prefs>view>settings>select from drop down select your preferred view for new sheets.
     
  11. Xandman

    Xandman New Member

    Joined:
    Dec 28, 2009
    Messages:
    11
    Likes Received:
    0
    just allows me to select normal or page layout...was hoping theres a setting that allows me to make zoom at 125% a default. :(
     
  12. enrique1784

    enrique1784 Member

    Joined:
    Aug 23, 2009
    Messages:
    157
    Likes Received:
    0
    Guys, anyone here who knows how can I make a keyboard shortcut for paste special in excel '08 for mac?... :D
     
  13. rg0nzales

    rg0nzales Member

    Joined:
    May 24, 2009
    Messages:
    327
    Likes Received:
    6
    Gender:
    Male
    Location:
    Las Piñas

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!