Next, we will go to the Data Tab and select Hide detail in the Outline group.įigure 3 – How to collapse rows Display the Expand/Collapse buttons If we do not have a Pivot table, we can also collapse rows in Excel by selecting any cell in the group.When we have a group in a Pivot table we wish to collapse, we will click on the (-) minus button at the side of the group’s bar to collapse the row.We will also learn how to expand or collapse rows and outlines in Pivot table fields.įigure 1 – How to collapse cells How to Collapse Rows within a Group In this tutorial, we will learn how to collapse multiple columns.
How To Collapse Rows And Columns In Excel – ExcelchatĮxcel allows us to collapse or expand an entire row, column, outline or group of data.
0 kommentar(er)
