Autofilter header row
in [General]
|
From: Mister Cul-de-sac Mister on 10 Apr 2010 06:33 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.
From: Gary''s Student on 10 Apr 2010 09:34 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.
From: ozgrid.com on 10 Apr 2010 21:53 AutoFilter can be applied to any row by selecting the row 1st. -- Regards Dave Hawley www.ozgrid.com "Mister Cul-de-sac" <Mister Cul-de-sac(a)discussions.microsoft.com> wrote in message news:56E34C1F-57AD-4B70-9FEB-605AC17E58C5(a)microsoft.com... > 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.
From: Mister Cul-de-sac on 11 Apr 2010 11:46 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.
|
Pages: 1 Prev: Audit Trail Next: How to convert text "JAN" into number 1? |