Select the cells or columns you want to ungroup and either follow the path Data > Outline > Ungroup or press Shift + Alt + Left key combination.Īlternatively, you can use the Clear Outline command in Ungroup menu to remove all groupings. You can ungroup your data in a similar way. Once the data is OK, select any cell in your data and click Auto Outline in Data > Outline > Group menu.īe warned that Excel can outline the data in rows if you have a total row as well. There should be a summary column with formulas after each group of detail columns.To make Auto Outline work, you need to provide at least these assumptions: However, the feature doesn't provide the expected results always. The Auto Outline feature may group your data perfectly with a single-click action. If you select a range instead of columns, Excel will ask you which aspect you want to group: Unfortunately, outlining feature does not support multiple range selections. To roll it back either use Shift + Alt + Left shortcut or Ungroup button. ![]() Then click the drop-down Ungroup button in the Outline button group. What does clear outline mean in Excel To remove an applied auto outline, click the Data tab in the Ribbon. ![]() Beware though, each time you apply the shortcut, Excel will add a new outline level. On the Data tab, in the Outline group, click the arrow under Group, and then click Auto Outline. In this topic, we are going to learn about Grouping Columns in Excel. Alternatively, you can use Shift + Alt + Right shortcut. Under the Data tab in the Ribbon, you can find the Group option in the outline section.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |