If you work with Excel on a Mac, you know that there are some key differences between the two versions of the software. One of the most frustrating differences is the way that absolute references are handled. On a PC, you can use the F4 key to toggle between relative and absolute references. But on a Mac, there is no such key. So how do you quickly switch between the two?
The answer is to use a keyboard shortcut. To toggle between relative and absolute references, simply hold down the Option key while pressing the F9 key. That's it!
If you find yourself using this shortcut often, you can create a keyboard shortcut for it by going to the Keyboard preferences in System Preferences. Click on the Keyboard Shortcuts tab and then click on the + sign at the bottom of the list. In the Add Shortcut window that appears, select Application Shortcuts from the drop-down menu. In the next field, type in the name of the application for which you want to create the shortcut. In this case, it would be Microsoft Excel. In the next field, type in the exact shortcut that you want to use. In this case, it would be Option-F9. Then click on the Add button. Now, every time you press Option-F9, Excel will toggle between relative and absolute references.
If you work with Excel on a Mac, this shortcut will save you a lot of time. Give it a try the next time you are working with absolute references in Excel.