Excel Help: How to get rid of this column and row?

New Contributor
2 Replies
So do you want to keep the grouping but get rid of the 1 to 7 options?
The problem with that approach is you may as well just hide the rows instead of grouping.

If you want to ungroup just highlight all the rows and go to Data > Ungroup


You are my answered prayer. I asked around for help, nobody even know what it is in the first place. I guess it's a feature nobody ever use. Some kids may have played with my keyboard while I'm away. I followed your advice and manage to make it vanish. 
Thank you so much. You're an angel. 

Related Conversations
@links .odc event tracking
Brent_Gamble in Excel on
0 Replies
Userform/Command Button to Appear in New Worksheet
Mr_Buttons in Excel on
2 Replies
Version 2001 Excel 365 and no Dynamic Arrays
MilesWilliams in Excel on
5 Replies
$ symbol changes format of cells automatically
gbetar01 in Excel on
2 Replies
Excel table formatting best practices question
Jerry1385 in Excel on
2 Replies
If/Then Formula Not Drawing Across Sheets
Matt010614 in Excel on
2 Replies