Excel: Shortcut for Absolute Reference

[polycat33]

On Excel on a PC you can press F4 after selecting a cell in order to make it an absolute reference (example: $E$2). But F4 doesn't work on a Mac. Does anyone know what key I can press to automatically turn E2 into $E$2 without having to do the dollar sign stuff manually?

 

[swiftaw]

A quick google: http://www.microsoft.com/mac/produc.../LIBRARY/tips_tricks/officex/xl_relabsref.xml


Answer: Apple+T

 

[jackgopher]

somehow the link provided didn't lead me to a shourtcuts page.

Do you happen to know whats the shortcut for wrapping text inside a cell (while typing, as alt+Enter in PC)?

Thanks

 

[swiftaw]

somehow the link provided didn't lead me to a shourtcuts page.

Do you happen to know whats the shortcut for wrapping text inside a cell (while typing, as alt+Enter in PC)?

Thanks

Control+Option+Return