What are Reference Styles?

Every Excel spreadsheet is organized into rows and columns. Rows are identified by numbers (1, 2, 3, etc.), while columns are typically identified by letters (A, B, C, etc.). This common labeling system is known as the A1 reference style.

In the A1 reference style, the column letter appears first and the row number appears second. For example, the cell located in column A and row 1 is called A1.

Excel also supports an alternative reference format called R1C1 reference style. In this format, both rows and columns are identified by numbers. The letter R represents the row number, while C represents the column number.

For example, the cell that would normally be called A1 becomes R1C1 when using this reference system.

The A1 reference style is the default format used in Excel and is the style most people are familiar with. However, some advanced users prefer the R1C1 reference style when working with complex formulas because it makes relative references easier to understand in certain situations.

The image below shows the difference between the two reference styles.

In the image on the left, the column headers are numbered instead of labeled with letters. This indicates that the worksheet is using the R1C1 reference style.

In the image on the right, the columns are labeled with letters such as A, B, and C. This is the standard A1 reference style that Excel uses by default.

In most situations you will want to use the A1 reference style because it is easier to read and matches the way Excel tutorials and documentation describe cell references.

If your spreadsheet is currently using the R1C1 reference style, you can switch back to the standard A1 style using Excel Options.

To access the Excel Options menu, begin by clicking the File tab located in the top-left corner of the Excel window.

Clicking the File tab will open the Backstage view. This screen contains several options for managing your workbook, including saving, printing, exporting, and accessing account settings.

At the bottom of the Backstage view menu, click Options. This will open the Excel Options dialog box where you can customize many settings related to formulas, calculations, and interface preferences.

Once the Excel Options dialog box appears, select the Formulas category from the list on the left side of the window.

Inside the Formulas section, you will see an option labeled R1C1 reference style.

If this box is checked, Excel will display columns as numbers instead of letters. To switch back to the standard reference style, simply uncheck the R1C1 reference style box.

After unchecking the box, click OK. Excel will immediately return to the standard A1 reference style.

You will now see column letters again at the top of the worksheet, such as A, B, C, and D, instead of numbers.