PDA

View Full Version : Excel F2 button


schrager
December 5th, 2007, 07:44 AM
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!

didoman
December 8th, 2007, 04:44 PM
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?

schrager
December 8th, 2007, 04:54 PM
Thank you!