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.
- › How to Use the Microsoft Excel Watch Window for Formulas
- › How to Add Numbers in Microsoft Excel
- › How to Use the ROUND Functions in Microsoft Excel
- › How to Number Rows in Microsoft Excel
- › How to Use the Scenario Manager in Microsoft Excel
- › How to Make a Data Table for What-If Analysis in Excel
- › How to Use the SEQUENCE Function in Google Sheets
- › What Is Moore’s Law and Why Are People Saying It’s Dead?