Switch Between Relative and Absolute References in Excel for Mac

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.

Switch Reference

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. 🙂

8 thoughts on “Switch Between Relative and Absolute References in Excel for Mac”

  1. 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.

  2. This entry helped me save tons of time! I’m converting to Mac so struggling big time.
    Thank you so much.

Comments are closed.