![]() ➤ After that, we will go to the Data tab > Outline > Group > Group.įinally, we can see a negative sign “ –” on the left side of the January Total column, which indicates that the rows before that column will become collapsed. ➤ To do so, first of all, we will select the data from cells B5 to D9. Here, we want collapsible rows for January month items, and we only want to see the January Total. In this method, we can create collapsible rows where we need them. Method-2: Create Collapsible Rows Manually Read More: How to Expand or Collapse Rows with Plus Sign in Excel (4 Easy Methods) We can only see the January Total and February Total rows. ➤ If we click on the “-” sign at the left, the rows become collapsed. We can also see two negative signs “ –” at the left, which indicates where the collapsible rows will generate. We can see in the top left corner the number of collapsible rows. Now, we can see the creation of 2 collapsible rows. ![]() ➤ After that, we will select Outline> Group> Auto Outline. ➤ To begin with, we will go to the Data tab in the ribbon. Here, we will automatically generate collapsible rows. Method-1: Create Collapsible Rows Automatically We will use 4 methods to collapse the rows of this table. The following Item Price List table shows the Month, Item, and Price columns. 4 Methods to Create Collapsible Rows in Excel
0 Comments
Leave a Reply. |