跳到主要內容

如何在Excel中識別並返回單元格的行和列號?

通常,我們可以根據其地址來標識單元格的行號和列號。 例如,地址A2表示它位於第1列和第2行。但是,標識Cell NK60的列號可能有點困難。 如果只有一個單元格的列地址或行地址,那麼如何識別其行號或列號? 本文將向您展示解決方案。


如果僅知道地址,如何識別行號和列號?

如果您知道單元格的地址,則很容易找出行號或列號。

如果單元格地址是 NK60,則顯示行號為60; 您可以使用以下公式獲得列 =列(NK60).

當然,您可以使用以下公式獲得行號: =行(NK60).


如果僅知道列或行地址,如何識別行或列號?

有時您可能知道特定列或行中的值,並且想要標識其行號或列號。 您可以使用“匹配”功能獲取它們。

假設您有一個表格,如以下屏幕快照所示。
doc識別第1列

假設您想知道“”,並且您已經知道它位於A列中,則可以使用以下公式 = MATCH(“墨水”,A:A,0) 在空白單元格中獲取行號。 輸入公式後,然後按Enter鍵,它將顯示包含“".

假設您想知道“”,並且您已經知道它位於第4行,則可以使用以下公式 = MATCH(“墨水”,4:4,0) 在空白單元格中獲取行號。 輸入公式後,然後按Enter鍵,它將顯示包含“".

如果單元格值與Excel中的某個值匹配,則選擇整個行/列

如果單元格值匹配某個值,則比較返回列值的行數,Kutools for Excel的 選擇特定的單元格 實用程序為Excel用戶提供了另一種選擇:如果單元格值與Excel中的某些值匹配,則選擇整行或整列。 屏幕左下方將突出顯示最左邊的行號或頂部的列字母。 更輕鬆,更獨特地工作!


廣告選擇特殊單元格,如果包含特定值,則選擇整行的列

Excel的Kutools - 使用 300 多種基本工具增強 Excel 功能。 享受全功能 30 天免費試用,無需信用卡! 立即行動吧!

最佳辦公生產力工具

熱門特色: 尋找、突出顯示或識別重複項   |  刪除空白行   |  合併列或儲存格而不遺失數據   |   沒有公式的回合 ...
超級查詢: 多條件VLookup    多值VLookup  |   跨多個工作表的 VLookup   |   模糊查詢 ....
高級下拉列表: 快速建立下拉列表   |  依賴下拉列表   |  多選下拉列表 ....
欄目經理: 新增特定數量的列  |  移動列  |  切換隱藏列的可見性狀態  |  比較範圍和列 ...
特色功能: 網格焦點   |  設計圖   |   大方程式酒吧    工作簿和工作表管理器   |  資源庫 (自動文字)   |  日期選擇器   |  合併工作表   |  加密/解密單元格    按清單發送電子郵件   |  超級濾鏡   |   特殊過濾器 (過濾粗體/斜體/刪除線...)...
前 15 個工具集12 文本 工具 (添加文本, 刪除字符,...)   |   50+ 圖表 類型 (甘特圖,...)   |   40+ 實用 公式 (根據生日計算年齡,...)   |   19 插入 工具 (插入二維碼, 從路徑插入圖片,...)   |   12 轉化 工具 (數字到單詞, 貨幣兌換,...)   |   7 合併與拆分 工具 (高級合併行, 分裂細胞,...)   |   ... 和更多

使用 Kutools for Excel 增強您的 Excel 技能,體驗前所未有的效率。 Kutools for Excel 提供了 300 多種進階功能來提高生產力並節省時間。  點擊此處獲取您最需要的功能...

kte選項卡201905


Office選項卡為Office帶來了選項卡式界面,使您的工作更加輕鬆

  • 在Word,Excel,PowerPoint中啟用選項卡式編輯和閱讀,發布者,Access,Visio和Project。
  • 在同一窗口的新選項卡中而不是在新窗口中打開並創建多個文檔。
  • 將您的工作效率提高 50%,每天為您減少數百次鼠標點擊!
Comments (10)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
hello, hoping maybe you can help. I am trying to do an index/match but it turns out the column i need to match may have multiple values separated by ',' so my match doesn't work. Any other ideas for finding a specific string of text in a range of cells? If I could get the row num then I think I could proceed with my index match.
This comment was minimized by the moderator on the site
Hi Michael!
Try using Text to Column, you can find this in Data Tab - Text To Column (Shortcut Alt + A + E). Use the comma delimited and select the cell where the data could be replaced. since there are different numbers seperated by Comma, it will fill in the required columns. Hop this helps.
This comment was minimized by the moderator on the site
we pull data into excel from a web source. It fills a column all the way to 2000. In the shortest possible way I want to spilt the data so that it fills column B, C, D, E, etc so when printing we are printer fewer pages.
This comment was minimized by the moderator on the site
Hi, i couldn't see the column index number while doing vlookup function manually in excel 2007. We can see the column and row number when we select the range. kindly help to make display column idex.
This comment was minimized by the moderator on the site
hi how to find multiple numbers present in one excel file with another excel file
This comment was minimized by the moderator on the site
hi i want to know is there any formula to look so many numbers present in one excel and to find in another excel sheet file.
This comment was minimized by the moderator on the site
HI I MADE A EXCEL SHEET IN WHICH I HAVE DETAILS OF PAYMENTS WE TAKE BY CARDS WITH DETAILS OF NAME REFERENCE NUMBER PER CUSTOMER , DATE ETC IF I WANT TO FIND OUT WHEN DID I TAKE THE PAYMENT OF PARTICULAR CUSTOMER , HOW COULD I SEARCH EXACTLY BY PUTTING CUSTOMER NAME ?
This comment was minimized by the moderator on the site
honestly this is not very helpful. :sigh: :cry: also it seems that it only helps with being able to find the cells address not anything about rows
This comment was minimized by the moderator on the site
how to find mobile number in this text "asmcud9999898754"dos12348"
This comment was minimized by the moderator on the site
Hi. Can I get say cell C3 to show the row No. Of any cell that I click on, I would like to use say C3 as the lookup cell in a vlookup command. Regards. Colin
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations