What is a Row in Excel

Last Updated: October 29, 2023
puneet-gogia-excel-champs

- Written by Puneet

Row in Excel

A row in Excel is a horizontal alignment of cells and it runs from left to right across the worksheet. Each row is identified by the unique number on its left side from where it started. The total number of rows you have in a single sheet is 1,048,576.

row1-in-Excel

Select a Row

To select a row, you just need to click on the header of the row where you have a numeric value. Then, it will select the entire row from the first cell to the last.

select-the-row-from-header

Another way to select the entire column is to use the keyboard shortcut. First, select any of the cells from the row that you want to select. Then, press and hold the shift key, and press the spacebar. Now, this will select the entire row.

Referring to a Row in Excel

As, you can see in the above snapshot that each row has its unique number, which starts with 1. And, to refer to a row, you need to use its number. So, if you want to refer a row 1, then you need to use this address like 2:2.

referring-single-row

You can see in the above example we are referring to row 1 by using its address in the sum function. Now, if you want to refer to multiple rows then you need to use an address that refers to the multiple rows.

referring-multiple-continuous-rows

In the above example, we are referring to the three rows from 2 to 4 and in the address, we have used the sum function (2:4) which means from row 2 to row 4.

referring-non-continuous-rows

Last, we are referring to three non-continued rows and to refer to these rows, we have used their address separately by using a comma in between them.

What is the Last Row in Excel

In a single worksheet, there are 1,048,576 total rows. And the last row number in Excel is 1,048,576. This count is fixed, and you can’t add more rows to a sheet. If you want to add more data, you need to insert a new worksheet that will also have the same number of rows.

last-row-in-Excel-worksheet