Forum Discussion
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?
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.
My sincere thanks!
You're very welcome. Grouping worksheets like that, is like magic when you're doing the same formatting on multiple sheets!
