Software

Ask something
Discussion Locked

Grouping Multiple Sheets in Excel

0 helpful
5 replies

by dools56

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a workbook that has 40 plus sheets in it. Is there any way to organize these sheets by grouping them and creating "sub-tabs"? Or is there any other way to group sheets to make them easier to navigate?

Thanks in advance!

5 replies

by highlander718

Depending on how many links you have between the sheets (formulas taking data from other sheets..), you can create several excel files grouping toghether as many sheets you want in each one of them, and create a "master" sheet with buttons that are opening the required Excel files/grouped sheets. Craeting a button and assigning a macro to it that will open a specific sheet is more tha easy if you are just using the wizard.
If you have lots of dependencies between the sheets this (or anyother solutions) will not work without lots of changes and recreation of formulas.

This discussion is closed to new replies.