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!
You should read it
- How to hide columns and hide rows in Excel 2016, 2013, 2010
- How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016
- How to fix column and header rows in Excel 2007, 2010, 2013, 2016
- How to temporarily hide rows and columns in Excel 2013
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- How to split columns in Word - Instructions on dividing columns in Word 2007, 2010, 2013, 2016
- How to convert columns into rows and rows into columns in Excel
- How to Hide Rows in Excel
- How to hide and show the rows and columns in Excel is extremely simple.
- How to hide and show the Ribbon toolbar in Word and Excel
- How to fix column and header rows in Excel 2016
May be interested
Cell counting function with data in Excel - Enclose example
How to create Header and Footer borders in Word 2019, 2016, 2013, 2010 and 2007
How to use SUMIF with 2 or more conditions in Excel
How to join PDF files with Foxit Reader
How to change the file extension XLSX to XLS to open in Excel 2003
What is a PivotTable? How to use PivotTable in Excel