Filters
 

I have a spreadsheet with 6000 rows. When ever I add a filter, it does not
filter everything. I can determine this because I take the filter off and do
a control find for the item. Excel then locates the cell information by
using the Control Find. I put the Filter back on and I can not find the cell
in that manner. Why does excel do this? How do I get around it?

Filters
 

Filter is only good up to 1000 rows. You may use Pivot instead

"Probber" wrote:

I have a spreadsheet with 6000 rows. When ever I add a filter, it does not
filter everything. I can determine this because I take the filter off and do
a control find for the item. Excel then locates the cell information by
using the Control Find. I put the Filter back on and I can not find the cell
in that manner. Why does excel do this? How do I get around it?

Filters
 

You can filter as many rows as you need (64k or 1MB).

There is a limit of 1000 unique entries that appear in the dropdown list--but
you can use Custom to filter to show what you want.

Teethless mama wrote:

Filter is only good up to 1000 rows. You may use Pivot instead

"Probber" wrote:

I have a spreadsheet with 6000 rows. When ever I add a filter, it does not
filter everything. I can determine this because I take the filter off and do
a control find for the item. Excel then locates the cell information by
using the Control Find. I put the Filter back on and I can not find the cell
in that manner. Why does excel do this? How do I get around it?

--

Dave Peterson

Filters
 

Make sure you select the range explicitly--don't let excel guess at the range.

If there are gaps (empty rows or columns), excel may not filter the range that
you want.

Probber wrote:

I have a spreadsheet with 6000 rows. When ever I add a filter, it does not
filter everything. I can determine this because I take the filter off and do
a control find for the item. Excel then locates the cell information by
using the Control Find. I put the Filter back on and I can not find the cell
in that manner. Why does excel do this? How do I get around it?

--

Dave Peterson