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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies