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.
- SSSVEDA DAY 7 – Every Team Needs Someone Who Understands Data - February 18, 2018
- SSSVEDA DAY 5 – When Data Analysis is Wrong - October 31, 2017
- SSSVEDA DAY 4 – Sharing the Excel Knowledge - July 18, 2017