How to group sheets so that they show in a drop-down style selection under a group name?

[lalakis1]

Hi guys,

Is there any way to group sheets so that they show like a drop-down style selection list? E.g. if sheets 1 to 5 are in group A, to show "group A" where sheet 1 would be, and if clicked, to show the list sheet 1 to sheet 5.

thank you once again

[FDibbins]

to the best of my knowledge, excel is not cabale of doing this the way you want.

not sure if this is of any help, but if you right-click on where "direction" arrows are at the bottom left, this will "pop-up" a window showing all sheets in that workbook?

[lalakis1]

I haven't found any way either, i guess it cannot be done in excel. What a disappointment for 2013 software, such a simple thing missing :P
Anyway, thank you very much for the reply mate.

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)