Switch Between Relative and Absolute References in Excel for Mac | Excel Semi-Pro

Switch Between Relative and Absolute References in Excel for Mac

by Gregory on November 29, 2010

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

Related Posts Plugin for WordPress, Blogger...
Howard February 14, 2012 at 5:39 pm

Thanks, this helped a lot.

Gregory February 14, 2012 at 7:51 pm

Always glad to hear I’m making things easier for someone.

jeff March 20, 2012 at 8:07 am

Thank you! This is my new favorite blog 🙂

Frustrated Advanced Excel User New to Mac

Hazel September 28, 2012 at 12:53 pm

This didn’t work for me – my Mac continues to make the error noise when I press the shortcut.

Gregory October 1, 2012 at 8:44 am

I’m sorry. Perhaps there is a difference with keyboards that are not US.

David December 7, 2012 at 8:09 pm

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.

Funda January 2, 2013 at 9:36 am

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

Comments on this entry are closed.

{ 1 trackback }

Previous post:

Next post: