Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does sort always default to include a header row. I want the.
I want the sort function to remember the last configuration I did, i.e., no
header row and to remember the columns I configured for the sort so I don't have to re do it every time I want to sort the data on my spreadsheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does sort always default to include a header row. I want the.
Excel makes best guesses as to what you want to do. The trick is to make
excel guess correctly. By including blank rows or columns you can change how Excel is interpreting your data. Beyond that you can create a macro that knows the range you want to sort and just run that each time. Hope this helps... "Jim Grace" wrote: I want the sort function to remember the last configuration I did, i.e., no header row and to remember the columns I configured for the sort so I don't have to re do it every time I want to sort the data on my spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort w/o header row - change default | Excel Worksheet Functions | |||
how do i set the default sort option to recognize a header | Excel Discussion (Misc queries) | |||
Excel needs to let the user set the sort default to "NO HEADER ROW | Excel Worksheet Functions | |||
How do I make the sort default to 'No header rows' | Excel Discussion (Misc queries) | |||
Changed Titled bar and now sort doesn't default to "Header Row" | Excel Discussion (Misc queries) |