How can I resize a level 2 grouping in a row-based outline structure.

Sid_Broach 

It seems like you are looking for a way to adjust the size of a Level 2 grouping in a row-based outline structure without having to recreate the entire outline structure.

While Excel does not offer a direct way to resize individual groupings within an outline, there are a few workarounds you can try:

1. Manually Adjust Row Heights:
• You can manually adjust the row heights to match the desired grouping. Select the rows you want to include in the Level 2 grouping, right-click, choose "Row Height", and enter the desired height. This method may be tedious if you have many rows to adjust.
2. Use a Macro:
• You can create a macro to automate the process of resizing the row heights for specific Level 2 groupings. The macro would select the rows for the desired grouping and adjust their height accordingly. Here's a basic example of what the macro might look like:

Vba code is untested, please backup your file frst.

Sub ResizeLevel2Grouping()
    ' Select the range of cells for the Level 2 grouping
    Dim rng As Range
    Set rng = Range("A1:A10") ' Adjust the range as needed
    
    ' Set the desired row height
    Dim rowHeight As Double
    rowHeight = 25 ' Adjust the row height as needed
    
    ' Resize the row heights
    rng.RowHeight = rowHeight
End Sub

You can customize this macro to select the specific range of cells for your Level 2 grouping and set the desired row height.

3. Use Formulas for Dynamic Row Heights:

• You can use formulas to dynamically adjust the row heights based on the number of rows in each grouping. For example, you could use a formula in the row height property of each row to calculate the height based on the number of rows in the grouping.

These workarounds may require some manual effort or scripting, but they should allow you to adjust the size of individual Level 2 groupings without affecting the rest of the outline structure. If you were comfortable with VBA scripting, the macro approach would likely be the most efficient solution. The text, steps and code were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.