Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with filter
Hello
I work with Excel 2003 and when I use the filter to scroll down my list of names, I can only see up to the names starting with M when my spreadsheet goes up to Z (of course). Any suggestion please? Many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with filter
Hi Pascale
Autofilter has a limit of 100 rows for display when a filter is applied. For a workaround take a look at Debra Dalgleish's site http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Pascale" wrote in message ... Hello I work with Excel 2003 and when I use the filter to scroll down my list of names, I can only see up to the names starting with M when my spreadsheet goes up to Z (of course). Any suggestion please? Many thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with filter
Sorry Roger, it's not exactly what I mean. Imagine you have 3 columns for 1st
name, surname and address. you select these column headings and go to Data, filter and auto. Appears next to each heading a little arrow pointing downward. when you click on the one next to "Surname", you see all the surnames sorted alphabetically. Without applying the filter but just scrolling down that list I can only see up to M rather than Z. Why is that and what can be done about it please? Thanks "Roger Govier" wrote: Hi Pascale Autofilter has a limit of 100 rows for display when a filter is applied. For a workaround take a look at Debra Dalgleish's site http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Pascale" wrote in message ... Hello I work with Excel 2003 and when I use the filter to scroll down my list of names, I can only see up to the names starting with M when my spreadsheet goes up to Z (of course). Any suggestion please? Many thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with filter
Hi Pascale
I apologise for the mistake in my previous post, I meant to type 1000 not 100. The same applies to the dropdown. If there are more than 1000 different names between A and M, then you will only see through to M Enter Number in cell A1 of a blank sheet. In A2 enter =ROW() drag A2 down through A3:A1100 Apply an Autofilter to A1, and use the dropdown How many do you see the list go up to? -- Regards Roger Govier "Pascale" wrote in message ... Sorry Roger, it's not exactly what I mean. Imagine you have 3 columns for 1st name, surname and address. you select these column headings and go to Data, filter and auto. Appears next to each heading a little arrow pointing downward. when you click on the one next to "Surname", you see all the surnames sorted alphabetically. Without applying the filter but just scrolling down that list I can only see up to M rather than Z. Why is that and what can be done about it please? Thanks "Roger Govier" wrote: Hi Pascale Autofilter has a limit of 100 rows for display when a filter is applied. For a workaround take a look at Debra Dalgleish's site http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Pascale" wrote in message ... Hello I work with Excel 2003 and when I use the filter to scroll down my list of names, I can only see up to the names starting with M when my spreadsheet goes up to Z (of course). Any suggestion please? Many thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with filter
Roger meant 1000 rows in the dropdown box, not 100.
Go to the site he pointed you to and re-read the information. Gord Dibben MS Excel MVP On Tue, 5 Jun 2007 07:17:01 -0700, Pascale wrote: Sorry Roger, it's not exactly what I mean. Imagine you have 3 columns for 1st name, surname and address. you select these column headings and go to Data, filter and auto. Appears next to each heading a little arrow pointing downward. when you click on the one next to "Surname", you see all the surnames sorted alphabetically. Without applying the filter but just scrolling down that list I can only see up to M rather than Z. Why is that and what can be done about it please? Thanks "Roger Govier" wrote: Hi Pascale Autofilter has a limit of 100 rows for display when a filter is applied. For a workaround take a look at Debra Dalgleish's site http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Pascale" wrote in message ... Hello I work with Excel 2003 and when I use the filter to scroll down my list of names, I can only see up to the names starting with M when my spreadsheet goes up to Z (of course). Any suggestion please? Many thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with filter
THANK YOU ! YOU ARE RIGHT. that is very helpful, many thanks again!
Pascale "Roger Govier" wrote: Hi Pascale I apologise for the mistake in my previous post, I meant to type 1000 not 100. The same applies to the dropdown. If there are more than 1000 different names between A and M, then you will only see through to M Enter Number in cell A1 of a blank sheet. In A2 enter =ROW() drag A2 down through A3:A1100 Apply an Autofilter to A1, and use the dropdown How many do you see the list go up to? -- Regards Roger Govier "Pascale" wrote in message ... Sorry Roger, it's not exactly what I mean. Imagine you have 3 columns for 1st name, surname and address. you select these column headings and go to Data, filter and auto. Appears next to each heading a little arrow pointing downward. when you click on the one next to "Surname", you see all the surnames sorted alphabetically. Without applying the filter but just scrolling down that list I can only see up to M rather than Z. Why is that and what can be done about it please? Thanks "Roger Govier" wrote: Hi Pascale Autofilter has a limit of 100 rows for display when a filter is applied. For a workaround take a look at Debra Dalgleish's site http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Pascale" wrote in message ... Hello I work with Excel 2003 and when I use the filter to scroll down my list of names, I can only see up to the names starting with M when my spreadsheet goes up to Z (of course). Any suggestion please? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter problem | Excel Worksheet Functions | |||
Auto Filter Problem (was VBA help) | Excel Discussion (Misc queries) | |||
filter problem | Excel Discussion (Misc queries) | |||
filter problem | Excel Discussion (Misc queries) | |||
Filter problem | Excel Worksheet Functions |