How do I turn on relative referencing when recording a macro in Excel for Mac 2016? There is a button in the Windows version but I cannot find this function in the Mac version. Surely it exists somewhere, given macros are pretty limited (useless, even) if they can only record absolute referencing... please help!
