Forum Discussion

Charles Heidel's avatar
Charles Heidel
Copper Contributor
Apr 26, 2018

Automatically hiding rows in one worksheet when the same rows are hidden in another worksheet?

When creating a workbook, can I hide rows in one worksheet and have those same row automatically hide themselves in another worksheet?

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    Charles-

     

    Sure thing.

     

    1. Click on the Sheets you want to edit using Ctrl  + Click

    2. Once you have selected the sheets it will look like this:

    3. Highlight the rows you want to hide.

    4. Right Click

    5. Click Hide

     

    The changes will be executed on all of the sheets you have selected.  To "un-group" the worksheets just double click on one of them.

     

      • Matt Mickle's avatar
        Matt Mickle
        Bronze Contributor

        You're very welcome.  Grouping worksheets like that, is like magic when you're doing the same formatting on multiple sheets!

Resources