Why don't all my data rows show up in auto-filter?
 

I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto filter
stops at row 1593. I've tried copying and pasting to a new workbook, turning
filters on and off, using format painter to ensure the formats are all the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?

Why don't all my data rows show up in auto-filter?
 

When you say it stops at 1593, what exactly do you mean? When you
apply a filter are all the row identifiers beyond 1593 coloured black
and these rows are visible? Or do you mean that you can only see
values in the pull-down up to that contained in row 1593? Excel only
displays the first 1000 (different) values in the pull-down.

Pete

On Apr 16, 3:46 pm, anromath
wrote:
I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto filter
stops at row 1593. I've tried copying and pasting to a new workbook, turning
filters on and off, using format painter to ensure the formats are all the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?

Why don't all my data rows show up in auto-filter?
 

Switch off the Autofilter.

Select the range of rows and column you want to include in your filter
before switching on the Autofilter again.
--
David Biddulph

"anromath" wrote in message
...
I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto filter
stops at row 1593. I've tried copying and pasting to a new workbook,
turning
filters on and off, using format painter to ensure the formats are all the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?

Why don't all my data rows show up in auto-filter?
 

The answer I gave below is for if the filter isn't including the rows.

If your problem is that you're not seeing more than 1000 different values in
the drop-down list, then the answer is different:
http://www.contextures.com/xlautofilter02.html
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Switch off the Autofilter.

Select the range of rows and column you want to include in your filter
before switching on the Autofilter again.

"anromath" wrote in message
...
I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto filter
stops at row 1593. I've tried copying and pasting to a new workbook,
turning
filters on and off, using format painter to ensure the formats are all
the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?

Why don't all my data rows show up in auto-filter?
 

Ah hah! That is exactly the problem -- there are more than 1000 different
values, so the values existing beyond row 1593 were not showing up in the
drop-down box.

I knew it had to be something simple and obvious. Thanks for your help Pete!

"Pete_UK" wrote:

When you say it stops at 1593, what exactly do you mean? When you
apply a filter are all the row identifiers beyond 1593 coloured black
and these rows are visible? Or do you mean that you can only see
values in the pull-down up to that contained in row 1593? Excel only
displays the first 1000 (different) values in the pull-down.

Pete

On Apr 16, 3:46 pm, anromath
wrote:
I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto filter
stops at row 1593. I've tried copying and pasting to a new workbook, turning
filters on and off, using format painter to ensure the formats are all the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?

Why don't all my data rows show up in auto-filter?
 

Thanks for feeding back. I see that David has given you a link to the
Contextures site which explains how to get round it.

Pete

On Apr 16, 4:26 pm, anromath
wrote:
Ah hah! That is exactly the problem -- there are more than 1000 different
values, so the values existing beyond row 1593 were not showing up in the
drop-down box.

I knew it had to be something simple and obvious. Thanks for your help Pete!



"Pete_UK" wrote:
When you say it stops at 1593, what exactly do you mean? When you
apply a filter are all the row identifiers beyond 1593 coloured black
and these rows are visible? Or do you mean that you can only see
values in the pull-down up to that contained in row 1593? Excel only
displays the first 1000 (different) values in the pull-down.

Pete

On Apr 16, 3:46 pm, anromath
wrote:
I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto filter
stops at row 1593. I've tried copying and pasting to a new workbook, turning
filters on and off, using format painter to ensure the formats are all the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?- Hide quoted text -

- Show quoted text -

Why don't all my data rows show up in auto-filter?
 

I don't this this will work for the person whose question I posted -- she is
a very, very unsophisticated user of Excel. But, I will keep it in mind for
myself. Thanks for teaching me a new trick!

"David Biddulph" wrote:

The answer I gave below is for if the filter isn't including the rows.

If your problem is that you're not seeing more than 1000 different values in
the drop-down list, then the answer is different:
http://www.contextures.com/xlautofilter02.html
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Switch off the Autofilter.

Select the range of rows and column you want to include in your filter
before switching on the Autofilter again.

"anromath" wrote in message
...
I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto filter
stops at row 1593. I've tried copying and pasting to a new workbook,
turning
filters on and off, using format painter to ensure the formats are all
the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?

Why don't all my data rows show up in auto-filter?
 

Yes, it's a useful one. I have a spreadsheet at home that has many more
names than will show up in the drop-down list, but I have a helper column
using the LEFT() function to give the first letter of the name, which I use
for an initial filter by that column to get the number of names to what
autofilter can handle.
--
David Biddulph

"anromath" wrote in message
...
I don't this this will work for the person whose question I posted -- she
is
a very, very unsophisticated user of Excel. But, I will keep it in mind
for
myself. Thanks for teaching me a new trick!

"David Biddulph" wrote:

The answer I gave below is for if the filter isn't including the rows.

If your problem is that you're not seeing more than 1000 different values
in
the drop-down list, then the answer is different:
http://www.contextures.com/xlautofilter02.html
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Switch off the Autofilter.

Select the range of rows and column you want to include in your filter
before switching on the Autofilter again.

"anromath" wrote in message
...
I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto
filter
stops at row 1593. I've tried copying and pasting to a new workbook,
turning
filters on and off, using format painter to ensure the formats are all
the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?