Excel TV ExcelTV
Excel Tips & Tricks

Command + T To Cycle Through Excel Cell References On A Mac

Updated
Command + T To Cycle Through Excel Cell References On A Mac

As frequent Excel users, we know the importance of absolute and relative references. On Windows operating system, one can use the F4 key to turn cycle through absolute and relative references, and everything in between. But there are a lot of users who use Excel on MAC and are clueless about how to access the same functionality.

No need to worry! Jordan Goldmeier (aka JLOOKUP) is here solve this mystery for us.

Let’s go for it!

Excel Shortcut on a MAC

The answer is simple!

COMMAND + T

Yes, that’s it. It can be used exactly as F4 is used in Windows. While typing the formula and right after selecting a reference, pressing COMMAND+T multiple times will make Excel cycle through absolute to relative reference and back on that selection. Also, while editing an already typed formula, one can just select or place cursor over a reference and press COMMAND+T to achieve the same result.

What’s next?

If you’re a MAC user, you need to remember this. It’s a long-awaited answer to our prayers. So, keep practicing it till it becomes muscle memory.

And do not forget to share this with your friends or colleagues who face similar frustration.

Written by

Jamani Arsalan
Jamani Arsalan

Consultant, International Professional Services

  • Project Management
  • Statistical Analysis
  • Health Analytics
I am a consultant, currently based in Middle East, at an international professional services firm. My work largely revolves around project management, and statistical analysis. And my professional interests include developing my knowledge within the discipline of health analytics.

Read more articles by Jamani Arsalan

Editorial standards

Fact Checking & Editorial Guidelines

Every article on Excel TV is held to a published editorial standard. The goal: accurate, current, and useful — without filler.

  1. Expert review. Drafts on technical Excel topics are reviewed by a contributor with hands-on, working knowledge of the feature being covered.
  2. Source validation. Claims about Excel behavior are tested in current Microsoft 365 builds. Third-party product claims are sourced from the vendor's own documentation.
  3. Disclosure. Affiliate links, sponsorships, and any commercial relationships that influenced a piece are disclosed in-line and at the foot of the article.
  4. Updates. Articles are revisited when Microsoft ships changes that affect the content. The most recent revision date is shown on every post.

Spot a problem? Email editor@excel.tv and we will look at it.

Subject-matter review

Reviewed by Subject Matter Experts

Technical Excel articles are reviewed by contributors with verifiable, hands-on experience in the topic — not generalist editors.

  • Qualified reviewers. Reviewers include Microsoft Excel MVPs, working business-intelligence practitioners, and Excel TV editorial staff. See each author's page for credentials.
  • Current to a known Excel build. Procedural articles state which Excel version they were validated against. Where Microsoft has since changed behavior, the article carries an inline update note.
  • Clarity check. Reviewers verify steps are reproducible by a reader at the assumed skill level — not just technically correct in a vacuum.

Want to contribute or review for Excel TV? See the about page.