Steps to Modify Excel’s Cell Referencing Format

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.

Also read: