Forum Discussion

goldspark's avatar
goldspark
Copper Contributor
Feb 26, 2019

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

excel

2 Replies

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Feb 26, 2019
    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

    • goldspark's avatar
      goldspark
      Copper Contributor
      Feb 26, 2019

      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. 

Resources