Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet that needs to be sorted. However, some of the rows need
to be grouped and sorted with its heading row. How can I do this? Renee |
#2
![]() |
|||
|
|||
![]()
You could add the heading to each row, then when you sort by the heading
column, all the related rows will stay with the heading. To hide the duplicate headings, you can use conditional formatting, as described he http://www.contextures.com/xlCondFor...html#Duplicate rreneerob wrote: I have a spreadsheet that needs to be sorted. However, some of the rows need to be grouped and sorted with its heading row. How can I do this? Renee -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |