Excel - The Row, Rows, Column, Columns functions

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)
Published by netty5. Latest update on July 24, 2013 at 06:07 AM by deri58.
This document, titled "Excel - The Row, Rows, Column, Columns functions," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Quickly create a simple holiday schedule
Excel/VBA - Deleting a string of character in a range of cells