One of the worksheets I've been using group rows for suddenly decided not to allow me to group anymore. I opened up my file this morning and all the group cells became hidden rows instead... and this isn't throughout the rest of my workbook... just this worksheet. I've been alt-d-g-g ing the shit out of it but nothing. Has this happened to anyone before? How to fix?
I don't think it's that I protected the sheet... right clicked the sheet tab and it still allows for the protection to be enabled, so means its not on...
Shouldn't you be using alt+a-g-g to group?
Both works. I'm used to the old excel 2003 shortcuts (it was originally alt d g), now in 07 add additional g
well, I just went back to an older copy of the model and just resaved so it's fine now. But I'd still like to know how to correct what happened for future ref. if anyone knows how.
Assumenda voluptatibus ut voluptates. Qui voluptatem a ut molestiae excepturi magni vel in. Cum iusto consectetur iure.
Quia ut et exercitationem dolorum nam labore. Totam qui doloribus aliquid suscipit totam nam. Non eos illo qui minima. Doloribus illo numquam cum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...