My group function in Data>Outline is unavailable

Copper Contributor

I would like to be able to group columns and rows but the function is greyed out

 

3 Replies

@KPritchard

 a) Does the workbook have protection?
b) Has the workbook been shared?
If a) is yes, then release it (Tools - Share workbook) and you can group again.



Nikolino
I know I don't know anything (Socrates)

If only the group bars are not displayed. File -> Options -> Advanced -> Show options for this workbook / worksheet: Show outline symbols if an outline has been applied -> checkmark!
you cant group in a named table...
you have to active a cell which is not part of the named table, then the option is available again