How to Get the row and column number of cell in Excel?

In Microsoft Excel , the cell’s row number and the column number is identified from its address. For example , if the cell is G3 , then the column number is 7 and the row number is 3. But assume that the cell is AA12 and you wish to identify the row and column number of the same.

How to Get the row and column number of cell in Excel?

You can automatically get it using the formula =ROW and =COLUMN by passing the respective parameters to get the row number and column numbers in Microsoft Excel 2016.

=ROW(AA12) should display 12

=COLUMN(AA12) should display 27.

Leave a Reply