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.
Nulla maxime iusto minima rerum voluptatem sed nobis. Qui debitis voluptatem fuga quia. Ipsum non vitae et et omnis.
Quidem debitis in voluptas aliquam. Voluptas quisquam blanditiis est inventore dignissimos dicta. Ab qui nisi id.
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...