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. In this topic, we are going to learn about Grouping Columns in Excel. You can leap over that tedium in a single bound with Auto Outline, a feature that gets Excel to examine. 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. Under the Data tab in the Ribbon, you can find the Group option in the outline section. Adding groups to a large worksheet can be tedious. 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. Beware though, each time you apply the shortcut, Excel will add a new outline level. Alternatively, you can use Shift + Alt + Right shortcut.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |