Organize Excel sheets into subsections

Spartacvs Posted messages 71 Status Membre -  
Spartacvs Posted messages 71 Status Membre -
Hello,
I'm having trouble finding an answer on Google, so I doubt it's possible, but it doesn't hurt to ask:
In the same Excel spreadsheet, I have a lot of sheets that follow one another, which is not easy for navigation. I would like to be able to organize these sheets into different groups so that I only have the corresponding sheets displayed each time, if possible with tabs to make it more ergonomic and accessible with a single click rather than having to do manipulations here and there (I made a small paint montage to illustrate the principle to make it clearer).

Originally, I tried to simply put them into multiple spreadsheets, but since some sheets are linked to each other, I have to open them all together, and also because sometimes I handle several files at the same time, I quickly find my taskbar overloaded and the problem remains the same...

If anyone has an idea for a simple and effective solution, I'm all ears.

Thank you in advance.



Configuration: Windows 7 / Firefox 38.0

2 réponses

didibonf Posted messages 418 Registration date   Status Membre Last intervention   96
 
Hello,
Maybe you can use macros associated with buttons. For example:
Button 1 --> hide sheets 4/5/6/7/8/9
Button 2 --> hide sheets 1/2/3/8/9
Button 3 --> hide sheets 1/2/3/4/5/6/7
0
Spartacvs Posted messages 71 Status Membre
 
Hello,
I will see how it works, indeed it could be a solution. Can the buttons always stay in the same position on the screen regardless of where we navigate on the sheet, or are they tied to specific cells?
0
didibonf Posted messages 418 Registration date   Status Membre Last intervention   96
 
The buttons are fixed in a sheet, it seems to me. You can place them at the top of the sheet and freeze the panes (or on the left) so that they will always be visible when scrolling through the sheet.
0
Spartacvs Posted messages 71 Status Membre
 
Hello,
Just a quick update, after struggling with the buttons: the issue is that they are only on one sheet.
Since I have quite a few sheets, that means creating buttons on each sheet (even more so since the idea is to organize them), which is really tedious.

Would there be another solution?
0