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.
Read More: How to Add Rows and Columns in Excel
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 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.
Download Practice Workbook
Download the following workbook to practice by yourself.
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.
- Excel VBA: Get Row and Column Number from Cell Address
- How to Convert Multiple Rows to Columns in Excel
- Excel VBA to Set Range Using Row and Column Numbers
- Switch Rows and Columns in Excel Chart
- How to Find Difference Between Rows and Columns in Excel
- How to Lock Column Width and Row Height in Excel
- How to Delete Empty Rows and Columns in Excel VBA
- Excel VBA: Set Range by Row and Column Number