[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.

How to Fix When Rows and Columns Are Both Numbers in Excel: Step by Step Solution

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.

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.

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.

Things to Remember

A1 Reference Style

Excel uses the A1 reference style by default. This reference style represents 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.

Download Practice Workbook

Download the following workbook to practice by yourself.

Fix Rows and Columns Are Both Numbers.xlsx

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.