Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort an outline without changing the hierarchy
How do I sort an outline without changing the hierarchy of the outline.
Hidden items stay in the same rows and visible items sort without regard to the level. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort an outline without changing the hierarchy
Maybe in a helper column you can have a code to maintain your
hierarchy, eg the first item could be 1.0, then subsidiary items are 1.1, 1.2, 1.3 etc, with the next item set at 2.0, and so on. Then you can sort on this column. Hope this helps. Pete On Dec 10, 7:20 pm, lelisabeth wrote: How do I sort an outline without changing the hierarchy of the outline. Hidden items stay in the same rows and visible items sort without regard to the level. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hierarchy Pyramid Chart | Charts and Charting in Excel | |||
Need ActiveX hierarchy. | Excel Discussion (Misc queries) | |||
Hierarchy in excel | Excel Discussion (Misc queries) | |||
Hierarchy in excel | New Users to Excel | |||
SUMPRODUCT - HIERARCHY | Excel Worksheet Functions |