Outline Groups

Excel Column Outline

Let me ask you a question.  How do you hide a row or a column? Since this is Excel we are talking about, there are several methods to accomplish this goal.

Common Approaches

One common approach is to select the row or column, and then select the Hide command, either from the Format Ribbon icon or the right-click shortcut menu.  Another common approach is by changing the row height or column width to zero.  These are probably the two most common methods.  However, there are problems with these methods.

One problem is that it is hard to tell if a row or column has been hidden.  You need to carefully examine the row and column headers and look for missing items.  For example, the column labels skip from B to F in the screenshot below.

Hidden Columns

Another problem is that it takes too long to unhide the rows or columns.  Let’s look at another method to hide rows and columns: outline groups.

Outline Groups

The Outline feature has been available in Excel for many years.  It is my preferred method for hiding rows or columns.  When a row or column is hidden with this feature, Excel provides a button that you can click to show/hide the group.  This provides a visual indicator letting you know a row or column is hidden, and, it makes it fast and easy to show/hide.

The feature is easy to use. Simply select the row/s or column/s you wish to hide.  Then, click the following Ribbon tab:

  • Data > Group > Group

The selected row/s or column/s will now be included in an outline group, as illustrated by columns C:E below.

Excel Column Outline

Now it is easy to hide and unhide the group, simply click on the outline button.  The screenshot below shows the hidden outline group.

Excel Hidden Outline

In addition to clicking the outline button to individually show/hide an outline group, you can show/hide all groups by clicking the little 1 and 2 buttons.  You can also create a hierarchy of nested groups, and each level gets a new outline button.  This feature provides an excellent way to hide rows or columns, and I hope you dig it.

And remember, Excel rules!



This article was written by jefflenning



    It’s really nice. I like it. Thank you.

  2. John Dunsdon

    A nice feature I wasn’t aware of. I will have to consider ways to use this in the future. Thanks.

  3. Dwain Hendrickson

    This was very informative. I think it is most efficient way to hide columns and rows and will use it gong

  4. James Higginson-Rollins

    And to un-hook the columns from ability to hide, use “Unhook”.

  5. James Higginson-Rollins

    And to un-hook the columns from ability to hide, use “Unhook”.

  6. Monique` O'Dell

    The ability to show both show and hide columns and rows with a button is very convenient.

  7. Logan Nemeth

    This is very useful. Being able to show both and hide both columns and rows is nice

  8. Maryann Losier

    Very cool (and easy). Thanks :)

  9. Ron

    This will be useful when preparing a table in excel to be used in a report.

  10. Karen

    Have seen this used before, but never knew how to set it up.

  11. Maura

    I love this tip, Jeff! It makes hiding columns easier to uncover and avoids missing any.

Leave a Reply

Your email address will not be published. Required fields are marked *

By submitting this form, you accept the Mollom privacy policy.