Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort, 2 row header
Hello,
I would like to preserve 2 rows for headers (don't want to merge cells, or use alt-enter to put text on two lines). How do I sort and preserve these 2 (or more) row headers? Thank you, Kath |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort, 2 row header
"Kath" wrote:
I would like to preserve 2 rows for headers (don't want to merge cells, or use alt-enter to put text on two lines). How do I sort and preserve these 2 (or more) row headers? Try selecting only the data rows (below the headers) then Data Sort Check "No header row" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort, 2 row header
Hi Max,
Thank you very much for the reply. It's just that I have a lot of data rows and was trying to avoid the cumbersome task of selecting them all each time I want to sort. Thank you, Kath |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort, 2 row header
"Kath" wrote:
Thank you very much for the reply. It's just that I have a lot of data rows and was trying to avoid the cumbersome task of selecting them all each time I want to sort. Perhaps try naming the data-range, then to select it thereafter, just click the name from the namebox ? Assuming data range is within A3:K100 Select A3:K100, click inside the namebox* and key-in: MyData Press Enter *box with the droplist just to the left of the formula bar Then, whenever you need to select the range for sorting, just click on the namebox droplist and select MyData -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort, 2 row header
Thank you very much Max.
That works!!! Kath |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort, 2 row header
You're welcome, Kath !
Glad it worked for you. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kath" wrote in message ups.com... Thank you very much Max. That works!!! Kath |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I sort with header not on row 1 | Excel Discussion (Misc queries) | |||
Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
Excel needs to let the user set the sort default to "NO HEADER ROW | Excel Worksheet Functions | |||
Changed Titled bar and now sort doesn't default to "Header Row" | Excel Discussion (Misc queries) | |||
How to exclude header row from sort button sorts? | Excel Discussion (Misc queries) |