If you want to remove all of the grouping in all rows and columns simultaneously, instead of clicking on the top half of the Ungroup button, click on the bottom half, which shows you a drop-down menu.

If you are interested in learning more keyboard shortcuts, you can do so here: 5 Keyboard Shortcuts for Rows and Columns in Excel.

The keyboard shortcut for removing groups is Shift + Alt + ←. Start by select the rows or columns that you want to ungroup. To remove groups, you follow almost the same process as before. As you click subsequent numbers, you'll be able to see more and more detail of the outline. Clicking each number will allow you to expand and collapse the data to the level you want. If you have groups within groups then you will see additional numbered levels. Clicking it again will expand the groups at the first level. These indicate the levels of the outline.Ĭlicking the Number 1 box will collapse all of the groups. When you create groups, you'll notice that in the upper left-hand corner of the spreadsheet some boxed numbers will appear. The keyboard shortcut for creating groups is Shift + Alt + →.

To create a group, simply select the rows or columns that you want to group together. Groups make it much easier for users of your worksheets to navigate your summary reports and only view detail rows/columns as needed. If your reports have a lot of rows/columns of data, they can easily start to feel overwhelming to some readers. Groups are a fast way to manage rows and columns that you hide and unhide frequently. Here's an image that shows the report with collapsed rows:Īnd here's how it looks when the rows are expanded: Why Groups? Make Your Reports Easier to Read Each group can be expanded or collapsed with the click of a button. The Groups feature creates row and column groupings in the Headings section of the worksheet. Groups and outlines allow you to quickly hide and unhide rows or columns in an Excel spreadsheet. Groups-and-Outlines.xlsx Download Grouping Rows or Columns

How to add multiple rows in excel 2016