Excel F2 button

Discussion in 'Switchers (Windows to Mac Converts)' started by schrager, Dec 5, 2007.

  1. schrager

    schrager Registered

    Joined:
    Dec 5, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    It's been a while since I used my Windows machine, but I think I used to click the "F2" button to edit a Windows Excel cell. Would someone please tell me how to do that in Apple's version of Excel. Currently, I find myself having to click my mouse on the entry window at the top of the screen. Also, how do I anchor cells, for instance $A$15? In Windows, I could scroll through the F4 key, but cannot figure out how to do that on the iMac. Finally, is there a key I can push to highlight all the linked cells in an Excel formula. Again, I currently have to click on the formula bar at the top of the screen.

    Thank you!
     
  2. didoman

    didoman Registered

    Joined:
    Feb 10, 2007
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    0
    To edit a cell: CONTROL+U
    To toggle between different absolute referencing types: CMD+T (when you are in edit-cell mode. or, you can just type in the $ signs...)

    I'm not sure of any shortcut to show referenced cells, I just click the formula bar for complicated equations. But a shortcut would be handy... maybe look in the help?
     
  3. schrager

    schrager Registered

    Joined:
    Dec 5, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Thank you!
     

Share This Page