PC/Windows 10
Microsoft 365
Version 2403 Build 16.0.17425.20176) 32-bit

Summary: I need to reset a level 2 grouping in a row-based outline structure to match a new size (i.e. adjust the number of lines within a sub-group directly).

Issue: I know how to set up outline levels, but the only way I know of to readjust the number of rows in a level 2 grouping is to delete the entire outline structure and recreate my outline groupings from scratch.

Hoped for Result: I would like to find a way to simply select and adjust the number of rows in any particular existing level 2 sub-grouping directly (rather than recreate the entire outline structure).

===========================================

Description: I have a simple spreadsheet in Excel where I keep weekly paycheck figures for my wife. I use a 2-level outline to divide the paycheck rows into Year (Level 1) and Month (Level 2) to make things easy to work with.

Each year, I copy the prior year’s outline into a new tab, empty the existing data, and use the now empty sheet as my template for the new year’s work. Of course, the number of paycheck weeks within each month changes with the year.  But I find that as I create the right number of weeks within each month (adding and deleting lines to match the paydates), the Month (level 2) grouping ‘edges’ get slightly off, that is, the beginning and end of that Level 2 group become off by a row of two as I add/delete lines within that particular group. That many times propagates down the level 2 outline, altering the boundaries for other months in ways both weird and wonderful.  I would like to reset any particular Month (level 2) grouping directly to match the new actual month groupings without affecting other level 2 groupings.  Can you help me?

​PC/Windows 10Microsoft 365Version 2403 Build 16.0.17425.20176) 32-bit Summary: I need to reset a level 2 grouping in a row-based outline structure to match a new size (i.e. adjust the number of lines within a sub-group directly). Issue: I know how to set up outline levels, but the only way I know of to readjust the number of rows in a level 2 grouping is to delete the entire outline structure and recreate my outline groupings from scratch. Hoped for Result: I would like to find a way to simply select and adjust the number of rows in any particular existing level 2 sub-grouping directly (rather than recreate the entire outline structure).===========================================Description: I have a simple spreadsheet in Excel where I keep weekly paycheck figures for my wife. I use a 2-level outline to divide the paycheck rows into Year (Level 1) and Month (Level 2) to make things easy to work with. Each year, I copy the prior year’s outline into a new tab, empty the existing data, and use the now empty sheet as my template for the new year’s work. Of course, the number of paycheck weeks within each month changes with the year.  But I find that as I create the right number of weeks within each month (adding and deleting lines to match the paydates), the Month (level 2) grouping ‘edges’ get slightly off, that is, the beginning and end of that Level 2 group become off by a row of two as I add/delete lines within that particular group. That many times propagates down the level 2 outline, altering the boundaries for other months in ways both weird and wonderful.  I would like to reset any particular Month (level 2) grouping directly to match the new actual month groupings without affecting other level 2 groupings.  Can you help me?  Read More

​