Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |