How to identify row and column number of cell in Excel?
Normally we can identify a cell's row number and column number according to its address. For example, the address A2 means it locates at Column 1 and Row 2. But it may be a little hard to identify the column number of Cell NK60. And if you only have the column address or row address of a cell, how do you identify its row number or column number? This article will shows you the solutions.
Comparing to return the row number of column value if cell value match certain value, Kutools for Excel’s Select SpecifiC Cells utility provides Excel users another choice: Select the entire row or entire column if cell values match certain value in Excel. Easier and more distinct for working!
Recommended Productivity SoftwareOffice Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).
It is quite easy to figure out the row number or column number if you know a cell's address.
If the cell address is NK60, it shows the row number is 60; and you can get the column with the formula of =Column(NK60).
Of course you can get the row number with formula of =Row(NK60).
Sometimes you may know a value in a specific column or row, and you want to identify its row number or column number. You can get them with Match function.
Supposing you have a table as following screenshot shows.
Supposing you want to know the row number of “ink” and you already know it locates at column A, you can use this formula of =MATCH("ink",A:A,0) in a blank cell to get it’s row number. After entering the formula, and then press the Enter key, it will show the row number of the cell which contains "ink".
Supposing you want to know the column number of “ink” and you already know it locates at Row 4, you can use this formula of =MATCH("ink",4:4,0) in a blank cell to get it’s row number. After entering the formula, and then press the Enter key, it will show the row number of the cell which contains "ink".
Is your problem solved?
Recommended Productivity Tools
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
More than 120 powerful advanced functions which designed for Excel:
- Merge Cell/Rows/Columns without Losing Data.
- Combine and Consolidate Multiple Sheets and Workbooks.
- Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
- Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
- More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...