How to create a button for hiding rows or columns

Have you ever seen the plus / minus button that hides or displays rows or columns? How to create it? Let’s see.

Table with hide/unhide button can look like this:Table_with_hide_button

After hiding:

Table_after_hiding_rows_columns

How to group columns

Select all columns you want to group and go to the menu Data >> Group. That’s all J The hide button will be displayed next to the last column above.

group_columns_step1

How to group rows

It’s the same as columns. So select all rows you want to group and go to the menu Data >> Group.

group_rows_step1

Automatic group columns and rows

Excel can create all groups in one step. It is based on the formulas in the worksheet. You don’t need to select any table. Go to the menu Data >> Group >> Auto Outline.

How to ungroup columns o rows

It’s simple. Select columns or rows you want to ungroup and go to the menu Data >> Ungroup. Automatic ungroup of all columns and rows is on Data >> Ungroup >> Clear Outline.

Video example

The example shows how to create and delete groups of columns and rows.  And how to do it automatically when the table contains the formula.

Add a comment »12 comments to this article

  1. Hello
    is there a way to rename the number for a Name instead ?

    Reply

  2. thanks a lot

    Reply

    • haha

      Reply

  3. Very Good

    Reply

  4. Hi,
    thanks for tutorial.
    The userform that we created to hide the columns in the workbook and unhide the hidden columns contains also a button to minimize userform. With to the drop-down list in the userform can be navigated between worksheets, the selected worksheet from the combobox is active and the column management(hide-unhide) of this worksheet is provided.

    Reply

  5. I did not know that something like this exists in Excel. Can I create it somehow automatically?

    Reply

    • There is Auto Outline button for that.

      Reply

  6. Thank you!
    I was searching for.

    Reply

  7. How to hide column in Excel? Nice solution. I had this issue: how to show hidden column or row? Where is the column visibility in Excel?

    Reply

  8. All things coedesirnd, this is a first class post

    Reply

    • coedesirnd
      considered
      how did you fail that badly?

      Reply

  9. This is awesome and exactly the stuff I was looking for… Thanks a lot

    Reply



Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress