ungrouping sheets

[lezawang]

Hi
I am reading this article https://www.wikihow.com/Ungroup-in-Excel about ungrouping sheets and it says "or press <kbd class="keyboard-key nowrap" style="border-width: 3px; border-style: outset; border-color: rgb(219, 219, 219) rgb(243, 243, 243) rgb(243, 243, 243) rgb(219, 219, 219); padding: 0px 2px; font-family: inherit; font-size: 0.85em; background-color: rgb(243, 243, 243); border-image: none;">⇧ Shift</kbd> while clicking one of the grouped sheets."

but that is not what I have found.

Lets say I grouped Sheet1, sheet2, sheet3, sheet4, sheet5,sheet6

if I click Shift+Sheet3 then, excel will ungroup sheet4,5,6 but keeps Sheet1,2,3 grouped
if I click Shift+sheet2 then, excel will ungroup Sheet3,4,5,6 but keeps sheet1,2 grouped

So it is not Shift + clicking any sheet will Ungroup all!

 

[Roderick_E]

I use ctrl + sheet -- works as expected

 

[lezawang]

Ctrl+sheet again, that would ungroup only one sheet but not all.

 

[Roderick_E]

ah sorry, right click on any sheet, choose ungroup sheets

 

[lezawang]

Ok yea "ungroup" is working but I thought there is a short cut to do that as per article