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.

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

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 :

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

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:

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

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

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

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:

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

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

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

- 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 :

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

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.

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

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

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

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

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

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:

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

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:

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

Similarly when selecting level 3:

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

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

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

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!