[Fixed!] Rows and Columns Are Both Numbers in Excel

Usually, the rows are labeled in numbers and the columns in letters in our Excel worksheets. But, there are some instances where this setting can get changed and we happen to see both the rows and columns in numbers. In this article, we will show you the step-by-step guidelines to fix Rows and Columns that are Both Numbers in Excel.

To illustrate, we’ll use a sample dataset as an example. For instance, the following picture represents an Excel sheet where the rows and columns are both numbers.

Rows and Columns are Both Numbers in Excel


Download Practice Workbook

Download the following workbook to practice by yourself.


How to Fix When Rows and Columns Are Both Numbers in Excel

Step 1: Select Excel File Tab to Fix If Rows and Columns Are Both Numbers

  • Firstly, we’ll select the File tab which you’ll find in the upper-left corner of the ribbon.


Step 2: Choose Options Feature

  • Then, select the Options feature on the lower-left side.

Rows and Columns are Both Numbers in Excel


Step 3: Uncheck a Setting

  • As a result, the Excel Options dialog box will pop out.
  • There, select the Formulas tab.
  • Subsequently, uncheck the box for the R1C1 reference style.

Rows and Columns are Both Numbers in Excel


Step 4: Press OK

  • Finally, press OK and it’ll return you to the Excel sheet.

Final Output to Fix Rows and Columns Are Both Numbers

Consequently, you’ll see the column labels in letters.

Read More: [Fixed!] Missing Row Numbers and Column Letters in Excel (3 Solutions)


Things to Remember

  • A1 Reference Style

Excel uses the A1 reference style by default. This reference style represents the column labeling in letters and row labeling in numbers.  They are known as row and column headers. We can refer to a cell by typing the column letter and the row number one after another. For instance, B5 denotes the cell at the junction of column B and row 5. We can also refer to a range of cells. For that purpose, type the cell reference present in the upper-left corner of the range at first. Successively, type a Colon (:), and the lower-right corner cell reference present in the range (B1:D5).

  • R1C1 Reference Style

There is also another referencing style available in the Excel sheet, the R1C1 reference style. In this style, the columns and the rows are labeled in numbers. The R1C1 reference style helps us to compute row and column positions in macros. In this style, Excel denotes the cell’s location with an “R” followed by a row number and a “C” followed by a column number. For example, the R8C9 cell is present in the 8th row and 9th column.


Conclusion

Henceforth, you will be able to Fix Rows and Columns that are Both Numbers in Excel following the above-described steps. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung

Aung

I'm Aung. Recently I earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo