Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter header row
My experience has been that the first row is where the controls (down arrow)
appear when autofilter is invoked. But I've now been sent a spreadsheet (just unformatted data in a large table) where the autofilter chooses the second row. I've compared the new spreadsheet with previous versions and don't see any difference in layout, etc. What can be causing this problem? Is there something "invisible" that tells Excel which is the header row for the data to be filtered? If I select row 1 and then click autofilter, the controls do appear on row 1 but otherwise it's always row 2 in this spreadsheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter header row
I have seen this problem if a column (usually on the right) does not have
data in the header cell. Make sure every column has a non-empty header cell! -- Gary''s Student - gsnu201001 "Mister Cul-de-sac" wrote: My experience has been that the first row is where the controls (down arrow) appear when autofilter is invoked. But I've now been sent a spreadsheet (just unformatted data in a large table) where the autofilter chooses the second row. I've compared the new spreadsheet with previous versions and don't see any difference in layout, etc. What can be causing this problem? Is there something "invisible" that tells Excel which is the header row for the data to be filtered? If I select row 1 and then click autofilter, the controls do appear on row 1 but otherwise it's always row 2 in this spreadsheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter header row
AutoFilter can be applied to any row by selecting the row 1st.
-- Regards Dave Hawley www.ozgrid.com "Mister Cul-de-sac" <Mister wrote in message ... My experience has been that the first row is where the controls (down arrow) appear when autofilter is invoked. But I've now been sent a spreadsheet (just unformatted data in a large table) where the autofilter chooses the second row. I've compared the new spreadsheet with previous versions and don't see any difference in layout, etc. What can be causing this problem? Is there something "invisible" that tells Excel which is the header row for the data to be filtered? If I select row 1 and then click autofilter, the controls do appear on row 1 but otherwise it's always row 2 in this spreadsheet. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter header row
Thanks, upon closer inspection I found that was exactly what had happened.
"Gary''s Student" wrote: I have seen this problem if a column (usually on the right) does not have data in the header cell. Make sure every column has a non-empty header cell! -- Gary''s Student - gsnu201001 "Mister Cul-de-sac" wrote: My experience has been that the first row is where the controls (down arrow) appear when autofilter is invoked. But I've now been sent a spreadsheet (just unformatted data in a large table) where the autofilter chooses the second row. I've compared the new spreadsheet with previous versions and don't see any difference in layout, etc. What can be causing this problem? Is there something "invisible" that tells Excel which is the header row for the data to be filtered? If I select row 1 and then click autofilter, the controls do appear on row 1 but otherwise it's always row 2 in this spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |