![]() ![]() Notice that the three plus signs in the left hand gutter of the worksheet indicate that there are currently three collapsed groups of rows. If we do the same for rows 1 through 5 and rows 15 through 19, we see that when these rows are grouped and collapsed, the original data is hidden from view making the important cells more easily found. Also, notice that when collapsed, the rows in the worksheet go right from row 7 to row 13, a sure sign that some of the rows in the worksheet have been grouped and are currently collapsed. This also signifies that rows 8 through 12 are part of a group and that the group is currently collapsed.Ĭlicking on the plus sign will expand the group again. If you click the minus sign next to row 13, rows 8 through 12 will collapse and the minus sign turns into a plus sign. This signifies that cells 8 through 12 are part of a group that is currently expanded. Next to rows 8 through 12, there is a line connecting these rows to the left and there is a minus sign next to row 13. You’ll immediately notice a change to the Excel worksheet that you may never have seen before. ![]() Click on the button labeled Group and select Group from the menu. Click on the Data tab on the Ribbon and locate a section of the Ribbon labeled Outline. Begin by selecting rows 8 through 12 with your mouse. As an example, let’s group rows 8 through 12 together, collapse them, and leave only the Average in row 13 visible.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |