Normally, Excel uses the A1 cell reference style which uses letters for column headings and numbers for row headings. However, if you notice there are numbers on both the row headings and column headings, that’s the R1C1 cell reference style. No worries. It’s easy to change it back.
To change from the R1C1 cell reference style back to to the A1 style, we will change a setting in the options. Click the “File” tab.
On the backstage screen, click “Options” in the list of items on the left.
On the “Excel Options” dialog box, click “Formulas” in the list of items on the left.
In the “Working with formulas” section, select the “R1C1 reference style” check box so there is NO check mark in the box.
Click “OK” to accept the change and close the “Excel Options” dialog box.
The columns should now have letters in the column headings.
When you change the cell reference style, it’s changed for all the worksheets in the current workbook. If you save the workbook with this change, any other workbooks you open or new ones you create will use the same cell reference style. If you close the workbook after making this change and you haven’t made any other changes, you will NOT be prompted to save your changes.
Notice that the drop-down list to the left of the formula bar shows which cell reference style is being used. It may seem like you can change the cell reference style using this drop-down list, but we discovered that for some reason it doesn’t work.
- › 11 Little-Known Excel Functions That Are Very Useful
- › How to Make a Data Table for What-If Analysis in Excel
- › How to Use the SEQUENCE Function in Google Sheets
- › How to Number Rows in Microsoft Excel
- › How to Use the Microsoft Excel Watch Window for Formulas
- › How to Use the Scenario Manager in Microsoft Excel
- › How to Add Numbers in Microsoft Excel
- › Clean Without Compromise and Save on the Roborock S7 Max Ultra