How to Calculate Total Number of Rows in MS Excel


When you are working with a Microsoft Excel spreadsheet, one of the most important pieces of information you need is the total number of rows in that spreadsheet. Microsoft Excel can be used to create many different calculations, and knowing the number of rows present in your spreadsheet can give you a lot of very valuable information.

  • Log on to your computer and open Microsoft Excel by clicking on the "Start" button, choosing "All Programs" from the menu and selecting "Microsoft Office." Choose "Excel" from the list of programs, then click the "File" menu and choose "Open" from the menu.

  • Hold the "Ctrl" key down and tap the "End" key on your keyboard. This will automatically move the cursor to the last row in the spreadsheet that contains an entry. If you simply want to know how many rows are in your spreadsheet you can use that row number. If you need to know how many rows actually contain data, move on to the next step.

  • Position your cursor underneath the last row that currently contains data and type "=COUNT(" hit the up arrow on your keyboard, then the period key. Hit the up arrow again and continue pressing the up arrow until you reach the top of the spreadsheet. When you have reached the top of the spreadsheet type ")" to close the calculation. You will see the number of rows that contain data.

  • Type the formula directly if you are working with a large spreadsheet. If you are working with a spreadsheet that contains a large number of rows, it will be easier to enter the formula directly. To enter the formula directly type "=COUNT(firstrow:lastrow)" For instance, if the first row in your spreadsheet is A1 and the last is Z1, the formula would be "=(COUNT(A1:Z1).

Related Searches

  • Photo Credit BananaStock/BananaStock/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!