Hide/Show rows with a cross
Solved
thibaut_francois
Posted messages
99
Status
Member
-
AelithX -
AelithX -
Hello,
I am creating increasingly comprehensive activity tracking tables... but as a result, they are becoming heavier and harder to read.
I would like to save space by giving users the option to show/hide detail rows with a button/a cross.
Here is an example of the stats I can track.
2010 2011
TOTAL BLOCK 4171 4091
Implantable Rooms 141 149
Endoscopy 390 422
Gynecology 618 580
etc...
The aim is for only the TOTAL BLOCK row to appear. And if the user wants the details, they should be able to click on a cross to reveal the details of the specialties.
Is it possible to do this in Excel? And above all, if it is possible, can you explain the process so that I can be autonomous and able to adapt it later to other formats?
Thanks to my future heroes of office work.
I am creating increasingly comprehensive activity tracking tables... but as a result, they are becoming heavier and harder to read.
I would like to save space by giving users the option to show/hide detail rows with a button/a cross.
Here is an example of the stats I can track.
2010 2011
TOTAL BLOCK 4171 4091
Implantable Rooms 141 149
Endoscopy 390 422
Gynecology 618 580
etc...
The aim is for only the TOTAL BLOCK row to appear. And if the user wants the details, they should be able to click on a cross to reveal the details of the specialties.
Is it possible to do this in Excel? And above all, if it is possible, can you explain the process so that I can be autonomous and able to adapt it later to other formats?
Thanks to my future heroes of office work.
4 answers
-
Hello,
For that, you can use the group/un-group functions in the data menu that provide exactly what you need.
--
Always zen. -
gbinforme is absolutely right: the outline mode was designed specifically to meet this type of need, and I recommend that you study it more closely; you will see that you can also hide/show columns and make hierarchical (or successive, or nested, if you prefer) groupings.
-> Very practical and very useful for large databases.
I also add that you can combine this manipulation with the Custom Views that allow you to have on screen (and in print) the different configurations that outline mode allows without increasing the file size.
And of course, have you already used the "Freeze Panes" feature to continue reading your row and column headers when you scroll through your screen?
Best regards.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂ -
Oh no... I should have specified that I knew about this feature...
But what I don't like is that it takes up space around the frame, with the appearance of the gray border...
And the cross is located in that border... And not exactly where a box breaks down...
That's what I was looking for: an alternative solution with a formula... or something else... -
Hello
an alternative solution with a formula...
You cannot hide/show with a formula.
You could create macro functions to do exactly what you want, but is that really wise?
It might weigh down your workbook and especially requires spending time designing and implementing them.
This feature is not necessarily perfect, but it has the merit of existing and allows for quite sophisticated displays.
You can also use simple or advanced filters on a suitable sheet.
--
Always zen-
-
When using an Excel feature, it must be used as it was designed.
To create a macro, it is necessary to define precisely the functionalities to be created: this is quite difficult for a novice as they will hardly see all the generated implications.
Then, these specifications must be coded, and the whole process takes many hours.
On the other hand, one must work with workbooks containing code to secure and make the necessary settings on the concerned workstations: this requires a different organization to be put in place. -
-
-
