Follow us on...
Follow us on Twitter Follow us on Facebook
Register
Results 1 to 3 of 3

Thread: Excel F2 button

  1. #1
    schrager is offline Registered User
    Join Date
    Dec 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel F2 button

    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. #2
    didoman is offline Registered User
    Join Date
    Feb 2007
    Posts
    23
    Thanks
    2
    Thanked 2 Times in 2 Posts
    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. #3
    schrager is offline Registered User
    Join Date
    Dec 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thank you

    Thank you!

 

 

Bookmarks

Posting Permissions

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