View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] qpager@gmail.com is offline
external usenet poster
 
Posts: 1
Default how to count rows

On Oct 31, 2:16*pm, Reen (donotspam) wrote:
How do you get a total count of the rows you use in your spreadsheet?


With the Status bar displayed (from the View menu), right click in the
status area (to the right of the bar) and select count.
Now simply highlight a column and the count figure will tell you how
many rows have values.

This actually counts the number of non-empty cells so it has a number
of uses.