| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto filter problem
Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas.
Thanks if you are able to assist Martin |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto filter problem
Select the whole range, making sure you include all the rows & columns you need, then select AutoFilter,
-- David Biddulph "Martin B" wrote in message ... Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas. Thanks if you are able to assist Martin |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto filter problem
for your info,
try reading this... http://office.microsoft.com/training...RP011459661033 happy holidays "Martin B" wrote: Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas. Thanks if you are able to assist Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell protection & Auto Filter | Excel Worksheet Functions | |||
| Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
| Counting items in auto filter - how? | Excel Discussion (Misc queries) | |||
| Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
| URGENT !! Auto Filter | Excel Discussion (Misc queries) | |||
Linear Mode
