Excel status bar: How did I get 65533 records.

G

Guest

I only have 116 line entries in a spreadsheet.

After Data/Filter I end up with this number in the Status Bar:

15 of 65533 records found. This should read
15 of 116 records found.

How do I fix it?
 
D

David Biddulph

Select the rows you wish to include in your filter before you set up the
filter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Filter Status Bar 2
How to obtain the number of filtered records in Autofilter 2
Getting 2 different answers for simple count 3
How do I make the status bar bigger? 1
BCM 2010 Status Bar 0
Setting for Excel automatically show count result in list ? 1
How can the count of filtered records always display? 1
Counting Multiple Records by specific criteria 5

Top