Excel Example – ROW function in Excel

Date:

Share post:

The ROW function in Excel returns the row number of a reference. For example, =ROW(C4) returns 4. The ROW function can be quite useful.

1. The ROW function below returns 8.

ROW function in Excel

2. If the reference is omitted, the ROW function returns the row number of the cell containing the ROW formula.

Without Reference

3. To clearly see this, select cell A2, click on the lower right corner of cell A2, and drag the ROW function down to cell A9.

Multiple Functions

4. If the reference is a range, the ROW function (entered in a single cell) returns the row number of the topmost row.

Topmost Row

Note: to return all 5 row numbers, first select the range A1:A5 (or another range of the same size), enter =ROW(C3:F7) and finish by pressing CTRL + SHIFT + ENTER. If you have Excel 365 or Excel 2021, simply select cell A1, enter =ROW(C3:F7) and press Enter.

5. Don’t confuse the ROW function with the ROWS function. The ROWS function counts the number of rows in a range.

ROWS function

Why using the ROW function in Excel?

6. For example, you can use the ROW function to sum every nth row in Excel (in the example below, every 3rd row).

Sum Every nth Row

Tip: use ROW, MOD and conditional formatting to shade alternate rows in Excel.

Practical Use Cases:

  • Creating dynamic formulas: You can use the ROW function to create formulas that adjust automatically as you add or remove rows.
  • Generating sequential numbers: By combining the ROW function with other functions like OFFSET or INDEX, you can generate sequential numbers or create dynamic lists.
  • Conditional formatting: You can use the ROW function to apply conditional formatting based on the row number.
See also  Excel Basics - Find & Select in Excel

Additional Tips:

  • You can use the COLUMN function to get the column number of a cell or range.
  • The ROW and COLUMN functions can be combined to create unique identifiers for cells within a range.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Related articles

Excel Example – Subtract in Excel

Subtract There's no SUBTRACT function in Excel. However, there are several ways to subtract numbers in Excel. Are you...

Excel Example – Most Used Functions in Excel

Most Used Functions Let's check out the 10 most used Excel functions. Visit our section about functions for detailed...

Excel Example – Move Columns in Excel

To move columns in Excel, use the shift key or use Insert Cut Cells. You can also change...

Excel Example – Flash Fill in Excel

Flash Fill Flash fill is a great Excel tool. Learn how to use flash fill to automatically extract data,...