| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter has gone mad!
We have a spreadsheet with Autofilters on. when you select a column to
filter the blue arrow appears on another column which is not the one filtered on. We have reinstalled Excel but this has not cured the problem, does anyone have any ideas as to why it seems to have gone insane? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter has gone mad!
Do you have a header in each column? Autofilter is sensitive to the absence
of headers! Regards, Stefi Piglet99 ezt *rta: We have a spreadsheet with Autofilters on. when you select a column to filter the blue arrow appears on another column which is not the one filtered on. We have reinstalled Excel but this has not cured the problem, does anyone have any ideas as to why it seems to have gone insane? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter has gone mad!
It does have headers, the file was an imported DAT file. There are
Autofilters on some apparently blank columns - which I believe are due to spaces being present in the DAT file. However if we filter on, say column K the blue filter arrow appears on column G. "Stefi" wrote: Do you have a header in each column? Autofilter is sensitive to the absence of headers! Regards, Stefi Piglet99 ezt *rta: We have a spreadsheet with Autofilters on. when you select a column to filter the blue arrow appears on another column which is not the one filtered on. We have reinstalled Excel but this has not cured the problem, does anyone have any ideas as to why it seems to have gone insane? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter has gone mad!
I've had trouble with no headers and pivottables--but never with autofilter.
Stefi wrote: Do you have a header in each column? Autofilter is sensitive to the absence of headers! Regards, Stefi Piglet99 ezt *rta: We have a spreadsheet with Autofilters on. when you select a column to filter the blue arrow appears on another column which is not the one filtered on. We have reinstalled Excel but this has not cured the problem, does anyone have any ideas as to why it seems to have gone insane? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter has gone mad!
Just a guess...
Do you use merged cells in this data? And you've autofit the columnwidths, right? What version of excel are you using? Piglet99 wrote: It does have headers, the file was an imported DAT file. There are Autofilters on some apparently blank columns - which I believe are due to spaces being present in the DAT file. However if we filter on, say column K the blue filter arrow appears on column G. "Stefi" wrote: Do you have a header in each column? Autofilter is sensitive to the absence of headers! Regards, Stefi Piglet99 ezt *rta: We have a spreadsheet with Autofilters on. when you select a column to filter the blue arrow appears on another column which is not the one filtered on. We have reinstalled Excel but this has not cured the problem, does anyone have any ideas as to why it seems to have gone insane? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter has gone mad!
I didn't create the spreadsheet, but it may well have had columns autofit.
Not sure about merged cells - I don't think so. Version is Excel 2003. "Dave Peterson" wrote: Just a guess... Do you use merged cells in this data? And you've autofit the columnwidths, right? What version of excel are you using? Piglet99 wrote: It does have headers, the file was an imported DAT file. There are Autofilters on some apparently blank columns - which I believe are due to spaces being present in the DAT file. However if we filter on, say column K the blue filter arrow appears on column G. "Stefi" wrote: Do you have a header in each column? Autofilter is sensitive to the absence of headers! Regards, Stefi âžPiglet99â ezt Ã*rta: We have a spreadsheet with Autofilters on. when you select a column to filter the blue arrow appears on another column which is not the one filtered on. We have reinstalled Excel but this has not cured the problem, does anyone have any ideas as to why it seems to have gone insane? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofilter has gone mad!
I think it has to do with the gaps in your data. This has happened to me
several times. I undo the filters, then if the headers are on row 1, I highlight the whole columns and then turn the auto filter back on. If your headers are not on row 1, then highlight the data area and turn on the auto filter. "Dave Peterson" wrote: I've had trouble with no headers and pivottables--but never with autofilter. Stefi wrote: Do you have a header in each column? Autofilter is sensitive to the absence of headers! Regards, Stefi âžPiglet99â ezt Ã*rta: We have a spreadsheet with Autofilters on. when you select a column to filter the blue arrow appears on another column which is not the one filtered on. We have reinstalled Excel but this has not cured the problem, does anyone have any ideas as to why it seems to have gone insane? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter | Excel Discussion (Misc queries) | |||
| 2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
| AutoFilter | Excel Discussion (Misc queries) | |||
| How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
| AutoFilter | Excel Discussion (Misc queries) | |||
Linear Mode
