Results 1 to 3 of 3

Expand or Collapse a group of cells in Excel 2010

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

  1. #1
    Senior Member
    Join Date
    Jun 2010
    Posts
    870

    Default Expand or Collapse a group of cells in Excel 2010

    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.


    Figure 1



    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.


    Figure 2



    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.


    Figure 3



    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.


    Figure 4



    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.



    Figure 5


    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.


    Figure 6


    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

  2. #2
    Junior Member
    Join Date
    May 2013
    Posts
    1

    Default Groups with + sign at word

    Quote Originally Posted by jagadish View Post
    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.


    Figure 1



    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.


    Figure 2



    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.


    Figure 3



    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.


    Figure 4



    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.



    Figure 5


    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.


    Figure 6


    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
    This works perfectly but is there anyway to put the sign beside the word rather than in the column? I have seen this done just not sure how!

    Appreciate any help.

    Nor

  3. #3
    Junior Member
    Join Date
    Mar 2014
    Posts
    1

    Default

    thnxxx dear

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •