This is a discussion on Expand or Collapse a group of cells in Excel 2010 within the Applications forums, part of the Tutorials category; Expand or Collapse a group of cells in Excel 2010 You can easily Collapse or expand a range of cells ...
Expand or Collapse a group of cells in Excel 2010
You can easily Collapse or expand a range of cells in an excel worksheet by using the ‘Group’ feature present on the Data tab of the Ribbon in the Excel 2010 Application. For example, if you have large volume of data present in your excel worksheet, then you can collapse some amount of data by tying it up in a group and make your worksheet well organized by having only the important data displayed in the worksheet as per your requirement. Below is a tutorial that will guide you on the usage of ‘Group’ feature in Excel 2010 Application.
1) Open the Worksheet in which you intend to collapse or expand a group of cells.
2) Then, select the range of cells that you want to collapse or expand.
3) Click on the “Data” tab and then under the Data tab, in the ‘Outline category’, click on the ‘Group’ icon and then select ‘group’ option from the drop down list.
4) Now, in the ‘Group’ dialogue box thus opened, select the Radio button that says ‘Rows’ if you wish to Collapse or expand rows or else select ‘Columns’ if you wish to collapse or expand Columns.
5) Now, you can observe a “-” symbol above the Row header or to the left of the the column header which indicates that, you can expand or collapse that group of cells which are within the indicated range.
6) Once you click on the ‘-‘symbol, the selected group of cells gets collapsed. Then, if you want to expand the group of cells, click on the ‘+’ symbol.
7) If you want to ungroup the cells, then click on the 'Ungroup' icon on the Data tab and then select 'Ungroup' option from the drop down list.
So, this how you can have your worksheet well organized with only the important data displayed in it and rest of the data collapsed.
Read Other Applications