How to use Group to hide, show rows and columns in Excel 2007, 2010, 2013, 2016, 2019

In the process of working with Excel spreadsheets, there are some contents that you do not want to display, you can use the Hide feature to hide it, but that way is very manual and sometimes takes a lot of time. In this article, you can use Group to hide and show columns in Excel.

To hide, show rows by using group is much more convenient than using other features like hide.

Use Group hidden, show

You only need to select the number of rows to hide -> go to Data tab -> Outline -> Group -> Group :

Only a small operation so you can use the Group feature to hide the rows. When the operation is successful on the left, a level 1 and 2 will appear and a minus sign will appear, starting from the selected row to the last row. In the minus sign, the rows are displayed:

If you want to hide the rows, click the minus sign -> minus signs to turn into plus signs and the hidden rows:

Use hidden Group, show columns

Similarly to hide columns by Group, you perform the same operation that only changes in step 1 instead of selecting the rows you select the columns to hide:

The symbol after successfully hiding the column is similar to hiding the rows:

- If you want to remove the row or column group feature, you just need to select the rows or columns that made the group feature to hide -> go to the Data tab -> Outline -> UnGroup -> UnGroup :

Create row and column hierarchies

- With the Group feature to hide, show rows or columns you can use this feature to decentralize the level of rows and columns like table of contents in Word

- The example has a spreadsheet with the following hierarchy:

+ There are two major items A and B

+ In Section A, there are Rank 1 and Grade 2

+ In Tier 1 and Grade 1 have levels 1, 2, .

+ In levels 1 and 2 there may be items a, b, c, d.

To decentralize the rows you make grouping of goods from inside out.

Step 1:   Create a hierarchy of items a, b, c, d are subsections of items 1, 2, 3.

Step 2: Create an item hierarchy greater than 1, ie, create a Group for items 1, 2, 3 .

Step 3: Create a Group for a group of grades 1 and 2.

Similarly you create Group for the remaining levels.

The result after creating the numeric value item above corresponds to the hierarchy. When clicking on the value of level 1 -> Number of rows 1 level displays other levels or other rows will be hidden, only items A, B are displayed:

When clicking on level 2 the previous level items are larger than it and level 2 is displayed, the levels with greater value are hidden:

Similarly when selecting level 3:

At group level 4 the contents are displayed in more detail to each item a, b, c, d:

So using the Group hidden feature shows rows or columns in Excel helps you work faster and easier. With the Group feature hidden columns to help you create hierarchies for worksheets with a large number of rows, this gives you an overview and science of your spreadsheet. Good luck!