In this chapter, we are going to take a brief look at hiding and grouping rows and columns.
Use this workbook for the chapter.
Note: This is the same workbook used in the Navigation Shortcuts chapter.
There may be times where you want to hide calculations occurring in different cells from users. You can hide rows individually or hide multiple rows. To hide rows, use the following steps:
These rows are still there; they’re just hidden from view. You will see that the rows go up to 7 and then skip to 13 in the next row. (See Figure 13.2)
To unhide a row, use the following steps:
You can hide and unhide columns. To hide columns, use the following steps:
In this case, both columns C and D will be hidden, and the column will skip from B to E. (See Figure 13.5)
To unhide these columns, use the following steps:
Grouping works the same way, but it’s even more convenient in some ways. To group columns, use the following steps:
This grouping bar has a collapsible button. When you select that button, those columns are collapsed into one group. The button will be replaced with an expand button, which will allow the user to see those columns visibly again once selected. (See Figure 13.9)
This allows you to expand or collapse quickly without having to right-click and choose Hide or Unhide.
To unhide a group, use the following steps:
To create two levels of grouping, use the following steps:
The numbers to the left of the grouping bars refer to the level of grouping. (See Figure 13.11)
If the number 1 is selected, it collapses everything. If the number 2 is selected, the first level expands (columns B, E, and F). If the number 3 is selected, all of the levels will be expanded. To get rid of the grouping, use the following steps:
Grouping and ungrouping rows works the same way. To group rows, use the following steps:
To group rows in multiple layers, use the following steps:
Just like with columns, you can expand and collapse these individually or as a full group using the numbers at the top. (See Figure 13.13)
With hiding, you right-click and select Hide and Unhide like the exercises before. Grouping can accomplish the same thing, but it gives you the options to quickly expand or collapse those groupings.
This content is provided to you freely by BYU-I Books.
Access it online or download it at https://books.byui.edu/bus_115_business_app/hiding_and_grouping.