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. |
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. |
All times are GMT +1. The time now is 01:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com