December 5th, 2007, 06:44 AM #1
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.
December 8th, 2007, 03:44 PM #2
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?
December 8th, 2007, 03:54 PM #3