For some data in Excel, we want to display it in groups, so that it is easier to organize. Here we need to create groups to achieve it. I will share the specific operations with you.
How to create a group in excel
1. Open the file with Excel.
2. Select the row or column where you want to create a group.
#3. Click the data in the menu bar, and then select "Create Group" in the toolbar.
#4. At this time, an icon that can be expanded or contracted appears on the left. The " " sign represents expansion, and the "-" sign represents contraction. At this time, the creation of the group is completed. .
#5. If you want to quickly clear all groups, also select "Data" - "Ungroup" - "Clear Outlined Display".
6. If you only want to clear a single group, you can select a group and then "Data" - "Ungroup".
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of How to create a group in excel. For more information, please follow other related articles on the PHP Chinese website!