Why Are My Column Labels Numbers Instead of Letters in Excel 2013?


When you refer to a cell in Microsoft Excel spreadsheets, you are likely accustomed to doing so by indicating the column, then the row number. For example, the top-left cell in your spreadsheet would be cell A1. However, you might be using Excel and find that the columns are labeled with numbers instead of letters. This can be confusing if you were not expecting it, and have not worked with this setup before.

This cell reference system is called R1C1, and is common in some fields and organizations. However, it is just a setting in Excel 2013, and you can change it if you would prefer to use the column letters with which you are familiar. Our guide below will show you how to turn onn the R1C1 reference style so that you can go back to column letters instead of numbers.

 

How to Change Excel 2013 Column Labels from Numbers Back to Letters

The steps in this article assume that you are currently seeing Excel column labels as numbers instead of letters, and that you would like to switch back. Note that this setting is defined for the Excel application, meaning that it will apply to every spreadsheet that you open in the program.

Step 1: Open Excel 2013.

 

Step 2: Click the File tab at the top-left corner of the window.

click the excel 2013 file tab

 

 

Step 3: Click Options at the bottom of the column on the left side of the window.

turn off r1c1 reference style in excel 2013

 

 

Step 4: Click the Formulas tab at the left side of the Excel Options window.

change column labels from numbers to letters

 

 

Step 5: Scroll down to the Working with formulas section of the menu, then uncheck the box to the left of R1C1 reference style. Click the OK button at the bottom of the window to apply your changes.

why are column labels numbers instead of letters in excel 2013

 

 

You should now be returned to your spreadsheet, where the column labels should once again be letters instead of numbers.

 

Are you having trouble fixing the constant issues that seem to occur whenever you try to print a spreadsheet? Our Excel printing tips can provide you with some helpful pointers and settings that can make printing your data a little less frustrating.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.