As said earlier, you can enable R1C1 in Excel in three different ways. You can use the Excel Options panel, Local Group Policy Editor, and Registry Editor. In the Excel Options panel, go to the Formulas tab and head to the Working with formulas section. Then, tick the R1C1 reference style checkbox to enable this setting.