Not able to Group rows or columns

Copper Contributor

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.

Thanks, I'll set that up

@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.

S1003.png

Great, thanks for this. Now - why would this option NOT be selected?! Strange.

@dunners74 

I don't know. It's selected by default.

Human fiddling, no doubt. It's a shared document in my case.