Forum Discussion

DOStegall1122's avatar
DOStegall1122
Copper Contributor
Dec 16, 2021

Not able to Group rows or columns

I have attached a copy of an existing spreadsheet and am trying to create both groups of rows and then groups of columns. I am able to do this in the original file but not in this copy. When I select the rows to be grouped (in this case rows 6-10) and hit the Group function under Data nothing happens. I then select the same rows manually from A6 to DG10 and hit the Group function and still nothing happens. The outline symbols never appear.

 

As mentioned I have been able to do this with the original spreadsheet but not with this one. What am I doing wrong?

 

I am running Windows 11 Home ver. 10.0.22000 Build 22000. Excel version 2111, Build 14701.20226

 

So the first question is - how do I attach the file. I keep trying to drag and drop it and that hasn't been working. I have also zipped it but still won't allow me to attach anything.

 

Any help would be greatly appreciated

 

7 Replies

  • DOStegall1122 New users can't attach files for reasons of security.

    You can upload your workbook to OneDrive, Google Drive, Dropbox or similar, obtain a link to share the file and post the link in a reply.

    • DOStegall1122's avatar
      DOStegall1122
      Copper Contributor
      Try this link: https://1drv.ms/x/s!An_R84AM5LQBhjohouKtRe3yyW1y?e=cAkOHN
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        DOStegall1122 

        Thank you! Try the following:

        • Select File > Options.
        • Select Advanced in the navigation pane on the left.
        • Scroll down to the section 'Display options for this worksheet'.
        • Tick the check box 'Show outline symbols if an outline is applied'.
        • Click OK.

Resources