To change the reference style in R1C1 in Excel, you can follow these aforementioned steps. First, open the Local Group Policy Editor and go to the Formulas section in User Configuration. Then, double-click on the R1C1 reference style setting and choose the Enabled option. Finally, click the OK button to save the change.