CELLROW Function

The CELLROW function returns the table row number of the current cell as a string into the current cell.

Syntax

CELLROW(<cell number>)

If a cell number is specified, it returns the table row of that cell starting at 1, as a string. This reference must be a direct cell reference. If a cell is not identified, then the function returns the row number, starting at 1, of the current cell.

It is also possible to use the CELLROW() function in skip and hide conditions on table rows.

Example 1

Enter CELLROW() in a table cell ABC.D100 returns 100.

Example 2

Enter CELLROW(ABC.D135) returns 135.

This function provides an easy way to include table row information in such a way that it is re-referenced when rows are added or deleted or when a table is re-labeled.

Related Topics