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.
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.
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.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.