Forum Discussion
Recording macros with relative referencing in Excel 2016
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 somew...
Hi Andrea,
This option is no longer available in Excel 2016 for Mac!
By the way, there is an https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/10323087-bring-back-relative-references-in-macro-recording in the Excel's suggestions box asking for this option to bring it back, you can vote for it.
Regards