Organize Excel sheets into subsections
Spartacvs
Posted messages
71
Status
Membre
-
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
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
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?
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?