Remove empty Outline group

Hi FrankK2185,

There are two ways to remove empty outline groups in Excel Version 2302 Microsoft 365 Apps for Enterprise:

1. Using the Outline Group window

1. Select any cell in the outline.
2. Click the Data tab.
3. In the Outline group, click Show Outline to open the Outline Group window.
4. Select the outline group that you want to remove.
5. Click the Delete button.
6. Click Yes to confirm.

2. Using the VBA Macro

1. Open the Visual Basic Editor (press Alt+F11).
2. Insert a new module (press Insert > Module).
3. Paste the following code into the module:

Sub RemoveEmptyOutlineGroups()

'Declare variables
Dim wks As Worksheet
Dim outlineGroup As OutlineGroup

'Set the worksheet variable
Set wks = ActiveSheet

'Iterate through all outline groups on the worksheet
For Each outlineGroup In wks.OutlineGroups

'If the outline group is empty, delete it
If outlineGroup.Count = 0 Then outlineGroup.Delete

Next outlineGroup

End Sub

1. Save the module and close the Visual Basic Editor.
2. To run the macro, press Alt+F8 to open the Macro dialog box.
3. Select the RemoveEmptyOutlineGroups macro and click Run.