EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Lookup & Reference Functions in Excel Excel ROW Function
Secondary Sidebar
Excel Functions
  • Lookup Reference Functions in Excel
    • VLOOKUP Function in EXCEL
    • VLOOKUP True
    • VLOOKUP Error
    • How to Match Data in Excel
    • Excel Match Function
    • Excel Lookup Function
    • ROWS Function in Excel
    • Excel INDEX Function
    • VLOOKUP Table Array
    • Excel OFFSET Formula
    • VLOOKUP For Text
    • IF VLOOKUP Formula in Excel
    • Mixed Reference in Excel
    • CHOOSE Formula in Excel
    • Excel COLUMN to Number
    • Excel Alternatives to VLOOKUP
    • HLOOKUP Examples
    • Excel VLOOKUP From Another Sheet
    • VLOOKUP with Sum
    • Fixing VLOOKUP Errors
    • Excel ROW Function
    • HYPERLINK in Excel
    • Address Excel Function
    • Excel COLUMNS Function
    • Excel REPLACE Function
    • OFFSET Excel Function
    • Excel GETPIVOTDATA Function
    • MATCH Function in Excel
    • VLOOKUP Function in Excel
    • HLOOKUP Function in Excel
    • LOOKUP in Excel
    • CHOOSE Function in Excel
    • TRANSPOSE in Excel
    • COLUMN Function in Excel
    • INDIRECT Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL COURSE
  • Online EXCEL ADVANCED Training

Excel ROW Function

By Pradeep SPradeep S

ROW Function in Excel

Excel ROW Function (Table of Contents)

  • ROW in Excel
  • How to Use ROW Function in Excel?

ROW in Excel

Row function in excel is used to get the row number of any selected cell irrespective of the values in a selected reference cell. To use the Row function, we just have to select the cell whose row number we want to identify; in return, we will have the row number of those reference cells. We can either select the row number or select the cell whose row number we need to know.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,368 ratings)

ROW Formula in Excel

Below is the ROW Formula in Excel :

ROW Formula

The ROW Function in Excel has the below-mentioned arguments:

  • [reference] : (Optional argument): The range of cells or cell reference for which you want the row number. ROW function always returns a numeric value

Note:

  • If the [reference] argument is left blank or not entered or omitted, then the function returns the row number of the current cell (i.e. It is the cell where the row function is entered).
  • Multiple references or addresses can be added or included in the ROW function.
  • If the reference argument is entered as an array, then the ROW Function in Excel returns the row numbers of all the rows in that array.

How to Use ROW Function in Excel?

ROW Function in Excel is very simple and easy to use. Let us now see how to use this ROW Function in Excel with the help of some examples.

You can download this ROW Function Excel Template here – ROW Function Excel Template

Example #1 – To Find out the ROW Number of the Current Cell

If you enter =ROW() in any cell in excel, it will return the cell’s row number. Let’s check out this. In the below-mentioned example, For the Cell “B8”, I need to find out the row number of that cell with the help of the ROW function.

Let’s apply the ROW function in cell “B8”, Select the cell “B8” where the ROW function needs to be applied.

Example 1

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “row” in the search for a function box, ROW function will appear in select a Function box. Double click on the ROW Function.

ROW function 1

A dialog box appears where arguments for the ROW function needs to be filled or entered, i.e. =ROW([reference]).

[reference]: (Optional argument) It is a cell reference for which you want the row number. Here it is left blank, or this argument is not entered because we want the row number of the current cell (i.e. It is the cell that the row function is entered into). Click OK.

Example 1-3

=ROW() without reference argument returns the row number of the cell where you entered row function, i.e. 8.

Row Formula Result of Example 1

Example #2 – To Find out the ROW Number of the Specified Cell

If you mention a cell reference with the ROW function, it will return the row number of that cell reference. Let’s check out this here.

In the below-mentioned example, the Data column contains “B13” in the cell B13; I need to find out the row number of that cell with the help of the ROW function.

Let’s apply the ROW function in cell “C13”, Select the cell “C13” where the ROW function needs to be applied.

Example 2

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “ROW” in the search for a function box, the ROW function will appear in select a Function box. Double click on the ROW function.

ROW function 2

A dialog box appears where arguments for the ROW function needs to be filled or entered, i.e. =ROW([reference])

[reference]: It is a cell reference for which you want the row number. Here it is “B13”. Click ok. after entering reference argument in row function, i.e. =ROW(B13).

 Example 2-3

=ROW(B13) returns the row number of that specified cell reference, i.e. 13.

Result of Example 2

Example #3 – To Find out ROW Numbers for a Range of Cells

When we apply the Row function for a specified range in excel, it will return the row number of the topmost row in the specified range; let’s check out this here.

In the below-mentioned example, the Table contains student score in column F & their subject score in column G. It’s in a range of F7:G11; I need to find out the topmost row in the specified range (F7:G11) with the help of the ROW function.

Let’s apply the ROW function in cell “G14”, Select the cell “G14” where the ROW Function needs to be applied.

Example 3

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “row” in the search for a function box, ROW function will appear in select a Function box. Double click on the ROW function.

ROW function 3

A dialog box appears where arguments for the ROW function needs to be filled or entered, i.e. =ROW([reference])

[reference]: is a cell or range of cells for which we want the row number.

Here we are taking input reference as a range of cells, i.e. F7:G11. Click ok. after entering the reference argument (F7:G11) in row function, i.e. =ROW(F7:G11).

Example 3-3

=ROW(F7:G11) returns the row number of the topmost row in the specified range, i.e. 7.

Row Function Result of Example 3

Things to Remember about the ROW Function in Excel

  • The ROW Function in Excel accepts an empty value, reference & range values in the argument.
  • The ROW function argument is optional, i.e. =ROW([reference]). Whenever there is a square bracket [] in an argument of excel function, then it indicates that the argument is an optional parameter, where you can skip or left blank.
  • Row Function is used as a nested function with other excel functions, i.e. It is commonly used along with other excel functions like ADDRESS, IF (Logical functions) & other functions with multiple criteria.
  • ROW Function has limitations, ROW Function considers only one input, so we cannot enter multiple references or addresses in a row argument.
  • In the ROW Function, either we can enter cell reference or range values in the arguments. If we try to use or add any of the other references along with that range, then the ROW Function will return an #NAME? error.

In the below-mentioned example, Here I have added “B8” cell reference along with range value “F7:G11”, i.e. =ROW (F7:G11B8)

ROW Formula Error 1-1

=ROW (F7:G11B8) will result in or returns #NAME? error.

ROW Formula Error 1-2

Recommended Articles

This has been a guide to ROW in Excel. Here we discuss the ROW Formula in Excel and how to use a ROW Function in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Add Rows in Excel Shortcut
  2. ROWS Function in Excel
  3. Autofit Row Height in Excel
  4. Excel Rows and Columns
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download ROW Function Excel Template

EDUCBA

Download ROW Function Excel Template

EDUCBA

डाउनलोड ROW Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more