Excel 2007 - Can you give groups names?

19,377

I think the expectation if you're grouping rows in Excel 2007 (on the Data tab/toolbar for those unfamiliar) is that you're grouping the data used to generate totals that are shown on the row immediately following the group. It's basically just a friendlier way to do what you've always been able to do with hiding rows/columns, and the grouping indicators in the margins are there to show you that something's hidden.

Share:
19,377

Related videos on Youtube

Joergi
Author by

Joergi

Updated on September 17, 2022

Comments

  • Joergi
    Joergi over 1 year

    I want to group a set of rows then hide them. Once hidden can you make it display some sort of text message.

    Like right now it just hides the rows.

    It is not very obvious that the rows are hidden. Can you give a message to be shown when hidden sort of like regions in C#

    region hi
    // some code
    #endregion
    

    if you collapse(hide) the region you will see at least "hi" and no right off the bat that something is hidden.