How are grouped columns ungrouped?
A)Select the entire worksheet and click Ungroup in the Subtotal group
B)Select one cell in the grouped columns and click Ungroup in the Outline group
C)Select all grouped columns and click Ungroup in the Outline group
D)Right-click and select Ungroup

Question

Quizplus · Accepted Answer

To ungroup grouped columns in Excel, you should select all the grouped columns first and then click on "Ungroup" in the Outline group on the Data tab. This action removes the grouping.

How Are Grouped Columns Ungrouped