Home > Topics > excel > body text

How to create a group in excel

angryTom
Release: 2020-02-28 10:00:18
Original
15926 people have browsed it

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

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.

How to create a group in excel

#3. Click the data in the menu bar, and then select "Create Group" in the toolbar.

How to create a group in excel

#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. .

How to create a group in excel

#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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template