Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to create dynamic reference table name in Excel
  • Randomize/ Shuffle List in Excel
  • Get column index in Excel Table
  • How To Filter Data in Excel
  • How To Perform and Interpret Regression Analysis in Excel

References

  • Multi-criteria lookup and transpose in Excel
  • Offset in Excel
  • Extract all partial matches in Excel
  • How to use Excel MATCH Function
  • Perform case-sensitive Lookup in Excel

Data Validations

  • Data validation must not exist in list
  • Excel Data validation date in next 30 days
  • Excel Data validation specific characters only
  • Excel Data validation only dates between
  • Excel Data validation number multiple 100

How to use Excel ROW Function

by

This Excel tutorial explains how to use the ROW function with syntax and examples.

Excel ROW Function Description

Microsoft Excel ROW function returns the row number of a cell reference.

The ROW function is a built-in function in Excel that is categorized as a Lookup/Reference Function. The ROW function can be entered as part of a formula in a cell of a worksheet.

Worked Example:   How to convert text string to array in Excel

Explanation: The Excel ROW function returns the row number for a reference. For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.

Worked Example:   Extract all partial matches in Excel

ROW function is used to get the row number for a cell reference or a range. For example:

=ROW(A3) // returns 3
=ROW(D5) // returns 5
=ROW(F10:J15) // returns 10

Syntax

The syntax for the ROW function in Microsoft Excel is:

ROW( [reference] )

Arguments

reference
Optional. It is a reference to a cell or range of cells.
Worked Example:   Get nth match with INDEX / MATCH in Excel

Returns

The ROW function returns a numeric value.

Note: If the reference parameter is omitted, it assumes that the reference is the cell address in which the ROW function has been entered in.

Post navigation

Previous Post:

MDETERM function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • Invoice status with nested if in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel

Date Time

  • How to join date and text together in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate working days left in month in Excel
  • How to get same date next month or previous month in Excel
  • How to calculate most recent day of week in Excel

Grouping

  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Categorize text with keywords in Excel
  • Group times into 3 hour buckets in Excel

General

  • How to get random value from list or table in Excel
  • AutoFit Column Width, AutoFit Row Height in Excel
  • How to calculate percent of students absent in Excel
  • Create dynamic workbook reference to another workbook in Excel
  • How to fill cell ranges with random text values in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning