| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting with AutoFilter
Hello, If I select the blank row above my list and below my header, and then activate the AutoFilter (Data/Filter/AutoFilter), when I click the Sort Ascending or Sort Descending option, the first row in my list remains the same. How do I include the first row? Thanks for your help! -- m.cain ------------------------------------------------------------------------ m.cain's Profile: http://www.excelforum.com/member.php...o&userid=32773 View this thread: http://www.excelforum.com/showthread...hreadid=526057 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting with AutoFilter
Hi
If you don't use Data/Sort, Excel will guess whether you have a header row or not. It will also guess at the range you want to sort. It's not foolproof, though! Andy. "m.cain" wrote in message ... Hello, If I select the blank row above my list and below my header, and then activate the AutoFilter (Data/Filter/AutoFilter), when I click the Sort Ascending or Sort Descending option, the first row in my list remains the same. How do I include the first row? Thanks for your help! -- m.cain ------------------------------------------------------------------------ m.cain's Profile: http://www.excelforum.com/member.php...o&userid=32773 View this thread: http://www.excelforum.com/showthread...hreadid=526057 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
| Autofilter not working correctly... | Excel Discussion (Misc queries) | |||
| Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
| Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
| Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Hybrid Mode
