lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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!
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!