Excel: Shortcut for Absolute Reference

Discussion in 'Mac Apps and Mac App Store' started by polycat33, Sep 20, 2007.

  1. polycat33 macrumors 6502

    Joined:
    Jul 1, 2007
    Location:
    Alexandria, VA
    #1
    On Excel on a PC you can press F4 after selecting a cell in order to make it an absolute reference (example: $E$2). But F4 doesn't work on a Mac. Does anyone know what key I can press to automatically turn E2 into $E$2 without having to do the dollar sign stuff manually?
     
  2. jackgopher macrumors newbie

    Joined:
    Nov 21, 2008
    #3
    somehow the link provided didn't lead me to a shourtcuts page.

    Do you happen to know whats the shortcut for wrapping text inside a cell (while typing, as alt+Enter in PC)?

    Thanks
     
  3. swiftaw macrumors 603

    swiftaw

    Joined:
    Jan 31, 2005
    Location:
    Omaha, NE, USA
    #4
    Control+Option+Return
     

Share This Page