Group Function - not working

Occasional Visitor


Hopefully, someone can help me. 

My group function with the data ribbon isn't working, even though there is a tick in the "show outline symbols if an outline is applied" box. this is only impacting one tab with the workbook, not all of it.


Any ideas on how to fix this would be amazing!  




1 Reply


File -> Options -> Advanced -> Show options for this workbook / worksheet: Show outline symbols, if an outline has been applied -> tick!

the setting does not apply to the entire workbook. Where it works there is a tick, not on the other sheets.


Here is an even easier way to toggle the outline symbols between fading in and out.

This show and hide shortcut is Ctrl + 8. If the 8 only uses the key below the function keys,

not the key on the Num Pad.

Activate the worksheet with the outline symbols and press Ctrl + 8 keys repeatedly to toggle

the outline symbols between hide and show.

Note: You can only use these key combinations to show or hide the outline symbols in the active sheet. If you want to apply them to the whole workbook, it won't work.



I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.