Comments on: How to group rows in Excel to collapse and expand them

Worksheets with a lot of complex and detailed information are difficult to view and read. Luckily, Microsoft Excel provides an easy way to organize data in groups allowing you to collapse and expand rows with similar content to create more compact and understandable views. Continue reading →

Comments page 2. Total comments: 56

  1. Really, it is very useful.

  2. I have a sorted column and want to create a group whenever the value value in the column changes. I get a 'Cannot create an outline' error message. There are hundreds of value changes. Is there a size limit to this feature.

    Thanks

  3. Hello!

    My outline symbols are not visible. The box is checked in advanced and I tried the ctrl + 8 and nothing is working! Please advise!

  4. How does this work if there is no arrow in low right corner?
    How can I open that sub menu?

  5. Thank you for the Outline Symbols Don't Show Up fix. I had 1 workbook with 5 sheets... and they would not show the group row symbols. If I clicked on "Show Detail" or "Hide Detail" in Outline Menu it would group, but with no way to see multi level groupings. I created 5 NEW sheets (same workbook) and copied the data and the new worksheets would show the group symbols. So question is, did I accidentally do a keyboard combination that "turned off" (or unchecked) the Show Symbol in the Advance Options? Just hoping to prevent that from occurring again.

  6. Hi Folks,

    When I unchecked the View under Headings in the Page Layout tab the Level Buttons disappears.
    Is there a way to move or relocate the Level Buttons anchored to top level corner or have the Level Buttons not disappear?
    Any help would be greatly appreciated! Thank you!

  7. How to group in Excel

  8. Is there a shortcut to hide the rows after using Shift-Alt-Right arrow to group them?

    1. Hi Jeff,

      You can use the Ctrl + 9 shortcut to hide rows and Ctrl + Shift + 9 to unhide.

  9. Is there any way to make a group, which contains all the rows in a table, extend by one row everytime you add a row to the table?

  10. Hi and thanks for the detailed information. My query is rather simple, but cant find how to do it.

    I have 90 groups of 11 rows, the first row of each 11 rows is a heading and I have laid them out alphabetically. How can I add another group of 11 rows between two sets of groups WITHOUT creating another level of grouping?

  11. How to hide ribbons only for one sheet in a workbook?
    need help please

    1. Mohammed:
      The only way I know to hide the ribbons or formula bars for one worksheet is by using some VBA code.
      There are various approaches to accomplishing this. You can find them by searching Google with Hide Ribbons in Excel.

  12. Hi! Thanks for the information. I do have a special question:

    Let's asume I have grouped rows from 10 to 15. Now I insert a new blank line above line 10 (e.g. above row 2). Grouping now remains in rows 10 to 15, but I want to have it shifted one row down to 11 to 16 (as the data is there). Is there any chance to "attach" the grouping to data instead of row-numbers?

    1. Sorry, I need to add the information, that I formatted row 1 to 8 as a table! If I add a row in this table, then the grouping remains on row 10 to 15. If I do not format row 1 to 8 as table, grouping shifts one row down if a blank row is inserted

  13. Hi
    Awesome information, thanks
    I have a question, Is there a way to name the groups?
    I would like to see if this can be posible

    thanks

  14. Hi,
    My data group function isn't working on one page in a workbook....works fine on the others.
    Any ideas how to fix it?
    Thanks, Becky

  15. Hello,

    Is there a way to record/write a macro that hides/unhide specific grouped rows? I want to be able to further customize the data that is being viewed by the user. - Simply writing VBA code that hides/unhides specific rows/columns within the worksheet does not seem to work when the data is outlined/grouped.

    Thanks!

  16. Dear,
    I want to copy different cell and rows and paste in another sheet as group data by excel vb. Thanks in advance.

  17. Hi there,

    Thanks so much for this, it is super helpful! I have followed this and have grouped rows under certain categories and it is clean and easy to follow. However, I created a Pivot Table and this does not seem to recognize the grouped rows in the data set. More specifically, I have listed item names (which is the pivot table filter) at the top of each of the grouped rows but it does not repeat within the rows - so the pivot table isn't reading the below rows as being within the filter item resulting in the pivot table not working. Is there a quick fix to this? Or do I need to put the filter item in every row within the groups in the data set? Thanks in advance for your help.

    1. Hello,
      For me to understand the problem better, please send me a small sample workbook with your source data and the result you expect to get to support@ablebits.com. Please don't worry if you have confidential information there, we never disclose the data we get from our customers and delete it as soon as the problem is resolved.
      Please also don't forget to include the link to this comment into your email.
      I'll look into your task and try to help.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)