Filtering a column and not all cells are available

G

Guest

When I try to filter a column which contains numbers from 0 to 9430 not all
those numbers are available to filter by. There are no blank cells in the
filtered column, all cells are formated as numbers. The filter will only
give me 0-6430 as filtered cells.

How do I get all the cells to 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

Merged cells disturb autofilter indicator 2
SUMIF with criteria "<>" & "=" 4
Filtering options are not available. 2
Replace single 0 without affecting other cells 1
How do I use advance filter correctly? 2
need help on either doing a loop and counting specific values orusing subtotal function 2
filtering subtotals and if functions 2
How to reference last non-blank cell value from a column cells? 2

Top