How to Expand or Collapse Rows with Plus Sign in Excel (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

An Excel file may contain lots of complex and detailed information. To read and view them easily, Excel has the facility to group similar items, expand, and collapse them. In this article, we will discuss briefly how to expand and collapse rows with the plus sign in Excel.


How to Expand or Collapse Rows with Plus Sign in Excel: 4 Methods

We will discuss how to expand and collapse rows using the plus sign in Excel in this article. We need to group the data based on criteria and then expand or collapse them. Our database contains the sales for the months of March and April of 2022. We will group them based on months.


1. Use Group Feature to Expand or Collapse Rows Manually

In this section, we will use the group feature to expand and collapse the dataset manually.

Steps:

  • First, select all cells of March-22.
  • Now, choose the Outline group from the Data tab.
  • Select the Group option.

Use Group Feature to Expand or Collapse Rows Manually

  • The Group window will appear.
  • Choose the Rows option and press OK.

Use Group Feature to Expand or Collapse Rows Manually

  • Look at the left side of the dataset.

There is a minus sign. When we press the minus sign, the dataset will collapse.

  • We can see that the data of the Mar-22 are collapsing. A plus sign appears now.

Use Group Feature to Expand or Collapse Rows Manually

If we want to extend the dataset, we need to click on the plus sign.


2. Expand and Collapse Multi-Level Rows in Excel

In the previous method, we expanded and collapsed the dataset of a single level. Now, we want to expand and collapse. In the dataset below, we have data from different categories with their sub-category. Our data is already grouped with the month category.

Steps:

  • Select 2 cells of Keyboard items of Mar-22.
  • Choose the Outline group of the Data tab.
  • Choose the Group option.

  • We see that the minus sign appears on the left side.

Expand and Collapse Multi-Level Rows in Excel

We can collapse the data set now.

  • In that way, we can apply grouping to the other data.

  • We collapse the dataset.

Expand and Collapse Multi-Level Rows in Excel

We grouped the data with multi-level.

Read More: How to Create Collapsible Rows in Excel


Similar Readings


3. Apply the Auto Outline Command

In this section, we will use the Auto Outline option to expand and collapse rows in Excel. This option can detect the category easily.

Steps:

  • Go to any of the cells from the dataset.
  • Select the Outline group from the Data tab.
  • Now, choose the Auto Outline option from the Group.

  • Look at the dataset now.

Apply the Auto Outline Command in Excel to Expand Rows

All data are grouped with requirements.

  • Collapse the dataset by pressing the minus sign.


4. Expand Rows with Entire Outline

In this section, we will expand the collapse dataset. Our data is already grouped. We will expand them.

Steps:

  • Select any of the cells. Choose the Outline option from the Data tab.
  • Select the Show Detail.

Expand Rows with Entire Outline in Excel

  • Look at the dataset.

Data are expanded here.


Expand and Collapse Columns with Plus Sign

We already showed how to expand and collapse rows. Now, we will how to expand and collapse columns.

Steps:

  • Then, go to the Data Select the Group option from the Outline.

  • The Group window will appear. Mark the Columns option and then press OK.

  • We notice that a minus sign appears at the top of the column indicator.

Expand and Collapse Columns with Plus Sign

  • When we click on the minus sign, the column will collapse.

Expand and Collapse Columns with Plus Sign

Now, a plus sign is showing. If we press the plus sign the columns will expand.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

In this article, we described 4 methods to explain how to expand and collapse rows with the plus sign in Excel. We also showed how to expand and collapse the columns. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.


Related Articles

Alok Paul
Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo