image
image

Go Back   macosx.com > Mac Help Forums > Switchers (Windows to Mac Converts)

Reply
 
LinkBack Thread Tools
  #1  
Old December 5th, 2007, 07:44 AM
Registered User
 
Join Date: Dec 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
schrager is on a distinguished road
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!
Reply With Quote
  #2  
Old December 8th, 2007, 04:44 PM
Registered User
 
Join Date: Feb 2007
Posts: 23
Thanks: 2
Thanked 1 Time in 1 Post
didoman is on a distinguished road
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?
Reply With Quote
  #3  
Old December 8th, 2007, 04:54 PM
Registered User
 
Join Date: Dec 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
schrager is on a distinguished road
Thank you

Thank you!
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump


All times are GMT -5. The time now is 07:39 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0 RC1
Copyright 2000-2010 DigitalCrowd, Inc.