Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
get sort to recognize header row
When I sort, 95% of the time Excel guesses wrong when it decides I have a
header row or not. Even flipping a coin would be better. Is there any way to get it to guess better? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
get sort to recognize header row
Try formatting the header differently--maybe bold, underlined?
widman wrote: When I sort, 95% of the time Excel guesses wrong when it decides I have a header row or not. Even flipping a coin would be better. Is there any way to get it to guess better? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
get sort to recognize header row
If I have to play with changing the format of the headers, I might as well just click the correct button once it identifies it wrong. I frequently have 3000 line sheets to sort, so I click on the corner to highlight the whole thing, and Excel thinks the text at the top is part of the numbers below. "Dave Peterson" wrote: Try formatting the header differently--maybe bold, underlined? widman wrote: When I sort, 95% of the time Excel guesses wrong when it decides I have a header row or not. Even flipping a coin would be better. Is there any way to get it to guess better? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
get sort to recognize header row
But you only have to change the format of the header row once.
If you have many worksheets, just select them all and format the header rows in one go. Gord Dibben MS Excel MVP On Tue, 24 Oct 2006 17:39:01 -0700, widman wrote: If I have to play with changing the format of the headers, I might as well just click the correct button once it identifies it wrong. I frequently have 3000 line sheets to sort, so I click on the corner to highlight the whole thing, and Excel thinks the text at the top is part of the numbers below. "Dave Peterson" wrote: Try formatting the header differently--maybe bold, underlined? widman wrote: When I sort, 95% of the time Excel guesses wrong when it decides I have a header row or not. Even flipping a coin would be better. Is there any way to get it to guess better? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 level sort, last special order | Excel Worksheet Functions | |||
how can I sort with header not on row 1 | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Header included in sort | Excel Worksheet Functions |