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.

Lisa wrote:

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.