Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Worksheet groupings

Workbooks with many worksheets can be difficult to navigate. One poster has suggested having multiple levels to the worksheet tabs.

As an extension to this, we could have worksheet groupings where several worksheets could be contained within a grouping. You could then select a particular grouping (which would look like worksheet tabs and be placed below the actual worksheet tabs) and then have access to all the worksheets in that particular grouping. There would also be an 'All' grouping that contained all the worksheets.

These grouping could be included in the workbook protection so that you could choose which worksheet groupings users could view

80 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gary shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    14 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        How much screen real estate are you willing to sacrifice for the groupings? It would be great if virtually no additional real estate was lost to worksheet groupings. Worst case, color tabs do help in identifying worksheet groups. Maybe the solution is similar to how graphic elements can be grouped: Group, Ungroup, Regroup in the right-click menu, with little real estate devoted to denoting the groupings; certainly not vertical screen real estate.

      • Jorge commented  ·   ·  Flag as inappropriate

        any updates? Would be useful. Now I constantly have to hide and then unhide tabs in order to make my workbook manageable

      • Jason Seifried commented  ·   ·  Flag as inappropriate

        Please do this. Something like the OneNote section->page->subpage would be terrific. Honestly I can't believe that excel doesn't have this yet.

      • Natalia commented  ·   ·  Flag as inappropriate

        This is an essential improvement. Nowadays the most Excels workbooks contain about 10-30 worksheets.

      • Walter commented  ·   ·  Flag as inappropriate

        i can't think of a single more transformative improvement than this. It would be a gamechanger in terms of how people would structure their files going forward.

        - Heavy user for 8 years

      • Neil commented  ·   ·  Flag as inappropriate

        Grouping of Worksheet tabs and the ability to define groupings by name would be a big improvement. I have used this macro which I expand upon/ change as needed.

        Sub MACRO1()
        '
        ' SHEET2_Macro
        '

        '
        Sheets("SHEET1").Select
        Sheets("SHEET2").Visible = True
        Range("A1").Select
        Dim sh As Worksheet
        For Each sh In Worksheets
        If sh.Name <> "SHEET1" And sh.Name <> "SHEET2" Then sh.Visible = xlSheetHidden
        Next
        Sheets("SHEET2").Select
        End Sub

      • Dean Kanitz commented  ·   ·  Flag as inappropriate

        With data, analysis and outputs there are typically multiple sheets, that address different issues and outcomes. With the ability of machines in 2016 and newer capabilities and Excel able to handle larger data sets there is a need to be able to better organize the data in layers or levels (sub-layers / levels). Currently, the only option is to add tabs to the to bottom of the screen in the same row. If there was an option to create a sub-tab below the existing it would enhance the organizational performance for those of us that want to both see more than the number of acronyms we can develop and tab colors. In a nutshell it would look like a flow chart, which may open some other routes for interaction with other MS products. Also, Excel functions that create tabs could ask in the menu if the user wanted to place the worksheet as a sub-tab.

      • Ste commented  ·   ·  Flag as inappropriate

        Why hasn't this been done already?! I was just looking for a plugin to do this, it would mean I could have my thirteen linked spreadsheets as one spreadsheet.

      • David commented  ·   ·  Flag as inappropriate

        It would be great to have a group function for sheets, similar to the one for rows/columns. This would allow someone to Collapse/Expand several sheets into one (ideally being able to name it rather than having a "+" sign) without being as intransparent and as the hiding function.

      • Simon Hurst commented  ·   ·  Flag as inappropriate

        The grouping could also be useful in applying similar protection to a set of worksheets in one go, rather than having to do so individually, or relying on VB.

      Feedback and Knowledge Base