Excel is one of the applications in the Office package that is equally useful in the workplace and at home or home office. Excel is able to store large amounts of information; Sometimes that information becomes too difficult to handle, so the use of data stored in an Excel spreadsheet becomes a growing problem as the file grows.
Used more often in commercial settings, home users often do not know that they can group and collapse rows and columns in an Excel spreadsheet to hide information until necessary. This is especially useful when you use formulas on a spreadsheet to summarize information and are only interested in those summaries most of the time.
Group rows and columns in an Excel spreadsheet
Let's say you have an Excel spreadsheet that looks like the one shown below. Note that there are several cells that contain data and that each data set is summarized in a separate cell (B6, B13 and B20).
The problem is that the data in cells (B1 to B5, B8 to B12 and B15 to B19) are not useful on a regular basis; You only care about the total, average and maximum values for each data set, respectively.
Using the function of Group In Excel, you can group this data separately and get it out of sight. When you need to view or edit the data, you can expand the groups and work with them again.
As an example, let's group rows 8 through 12, collapse them and leave only the Average in row 13. Start by selecting rows 8 through 12 with your mouse. Click on the tab Data in the Headband and locate a section of the Headband labeled as Contour . Click on the labeled button Group and select Group in the menu
Immediately notice a change in the Excel spreadsheet that you may have never seen before. Next to rows 8 to 12, there is a line that connects these rows to the left and there is a minus sign next to row 13. This means that cells 8 to 12 are part of a group that is currently expanded.
If you click on the minus sign next to row 13, rows 8 through 12 will collapse and the minus sign will become an ms sign. This also means that rows 8 to 12 are part of a group and that the group is currently collapsed.
Clicking on the plus sign expand the group again. Also, keep in mind that when they are contracted, the rows in the worksheet go to the right of row 7 to row 13, a sure sign that some of the rows in the worksheet have been grouped and collapsed currently.
If we do the same for rows 1 to 5 and rows 15 to 19, we see that when these rows are grouped and collapsed, the original data is hidden from view, which makes important cells more easily found. Note that the three plus signs in the left margin of the spreadsheet indicate that there are currently three groups of contracted rows.
Grouping and contracting cells in Excel is not limited to rows; You can also group and collapse columns. It is even possible to create groups within groups to better organize the data that has become difficult to work with in an Excel spreadsheet.