Ungroup

Ungroups the selection. In a nested group, the last rows or columns that were added are removed from the group.

To access this command...

From the menu bar:

Choose Data - Group and Outline - Ungroup.

From the tabbed interface:

Choose Data - Ungroup.

On the Data menu of the Data tab, choose Ungroup.

From toolbars:

Icon Ungroup

Ungroup

From the keyboard:

+ F12


Deactivate for

Rows

Removes selected rows from a group.

Columns

Removes selected columns from a group.

Please support us!