0
Thanks

A few words of thanks would be greatly appreciated.

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)
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Original article published by . Translated by netty5. Latest update on 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/).

0 Comments