How to count number of rows in Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-count-number-of-rows-in-Excel.png)
If you have a worksheet with a huge amount of data and you want to quickly know the number of rows, without scrolling down the worksheet, Excel offers a chance to count the number of rows. To do that proceed as follows.
Step 1 – Select a column
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-count-number-of-rows-in-Excel.gif)
– Click on the column header to select a column of the data you want to count the rows.
Step 2 – Count the rows
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-count-number-of-rows-in-Excel.gif)
– Locate the “status bar” on the bottom right of the Excel windows;
– Locate the “count” item. This number represents the amount of rows for the selected column. Be aware that also the first row with the header is counted.