I’m a longtime user of Excel for Windows, but recently a newbie with Excel 2008 for Mac where I found that out the Windows shortcut F4 doesn’t work to switch between relative and absolute references when editing a formula. Thankfully Excel 2011 has a Switch Reference toolbar icon on the Formulas Ribbon, as shown below.
Keyboard Shortcut in Excel for Mac
In trying to find a shortcut, I opened up Excel 2008 for Mac, went to the Help search bar, typed in “Excel Keyboard Shortcuts,” and was able to find out that Cmd+T toggles the formula reference style between absolute, relative, and mixed.
So I go back to Excel 2011 for Mac and, lo and behold, ⌘+T works there as well.
Gotta love that keyboard shortcut list in Help. It’s my new best friend in Excel for Mac. 🙂
Thanks, this helped a lot.
Always glad to hear I’m making things easier for someone.
Thank you! This is my new favorite blog 🙂
Sincerely,
Frustrated Advanced Excel User New to Mac
This didn’t work for me – my Mac continues to make the error noise when I press the shortcut.
I’m sorry. Perhaps there is a difference with keyboards that are not US.
Thanks so much for the tip on switch reference. I couldn’t get it to work and moved over to my PC to finish my spreadsheet. Now, after reading your tip, I’m happily back on the Mac.
This entry helped me save tons of time! I’m converting to Mac so struggling big time.
Thank you so much.