You can use COUNTA over a column to give you this, eg:

=COUNTA(A:A)

Hope this helps.

Pete

Right click the status bar at the bottom of the Excel window and choose
Count from the list of options. Now when you select a column or filter
a range it will tell you how many items there are.

Hi Lisa: when you say records of "excel document" is it for one worksheet or
for all the worksheet in a workbook ??

I would like to point out that the result may be different from Pete's method (COUNTA) and Lori's method (AutoCal) if you have hidden rows.  COUNTA includes all hidden (manual and filtered) rows while AutoCal counts the records on the screen that you can see.  

There is a third method - SUBTOTAL (3, 103 etc. etc.) if you want to ignore certain type of hidden rows and use the result in a formula.  See Excel Help for details.  

One more point - don't forget to subtract header rows if any.

Feel free to correct me if I am wrong.

Epinn

Wondering if there is a way to indicate the Number of Records in an excel
document in a particular area without using the filter option.  So what I
mean is - when you filter on a field for a piece of information down in the
bottom of your screen it will tell you found 2 0f 2 Records Found.  Is there
a way to have a number there indicating how many records are on the sheet?

Any help you can provide would be great.

Thanks in advance.