My group function in Data>Outline is unavailable

%3CLINGO-SUB%20id%3D%22lingo-sub-1573024%22%20slang%3D%22en-US%22%3EMy%20group%20function%20in%20Data%26gt%3BOutline%20is%20unavailable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573024%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20be%20able%20to%20group%20columns%20and%20rows%20but%20the%20function%20is%20greyed%20out%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1573036%22%20slang%3D%22de-DE%22%3ESubject%3A%20My%20group%20function%20in%20Data%26gt%3BOutline%20is%20unavailable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573036%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F752612%22%20target%3D%22_blank%22%3E%40KPritchard%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Ea)%20Does%20the%20workbook%20have%20protection%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3Eb)%20Has%20the%20workbook%20been%20shared%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3EIf%20a)%20is%20yes%2C%20then%20release%20it%20(Tools%20-%20Share%20workbook)%20and%20you%20can%20group%20again.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

 

2 Replies
Highlighted

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

Highlighted
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!