Excel - The Row, Rows, Column, Columns functions

October 2016

You have a table, named as MyTable(for example):
Insert/Name/Define..... check all the the boxes of the table and define this table as MyTable
In this table, you want to know, whatever its location, and even if you move your cursor:
  • The row number of the 1st row of the table: =ROW(MyTable)
  • The column number of the 1st column:=COLUMN(MyTable)
  • Number of rows present in the table: =ROWS(MyTable)
  • Number of columns present in the table: =COLUMNS(MyTable)

Related :

This document entitled « Excel - The Row, Rows, Column, Columns functions » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.