When in filter mode status bar doesn't show range of cells filted

G

Guest

I am working with a large excel sheet of data but when I wish to know the
range of data within this for instance when I filter out specific data, it
doesn't show me on the status bar how many cells have been selected, it
simply states FILTER MODE. I need the status bar to tell me 100 of 250
cells have been selected. Have I turned off a certain function?

Please help.
 

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
Sum after Filter, Count after Fliter 2
I can't see totals in status bar when I highlight cells 3
Excel Issue with "Average" showing in Status Bar 2
How do I get the filter mode to show the good row count? 2
How do I force Excel to show filter totals in the Status bar? 2
Status bar msg is gone 5
how to scroll while in formula bar (Excel 2007) 0

Top