00_lead_image_r1c1_to_a1

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.

01_clicking_file_tab

On the backstage screen, click “Options” in the list of items on the left.

02_clicking_options

On the “Excel Options” dialog box, click “Formulas” in the list of items on the left.

03_clicking_formulas

In the “Working with formulas” section, select the “R1C1 reference style” check box so there is NO check mark in the box.

04_turning_off_r1c1

Click “OK” to accept the change and close the “Excel Options” dialog box.

05_clicking_ok

The columns should now have letters in the column headings.

06_a1_cell_reference_style

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.