How to group rows above Excel Office 365 on Mac

Copper Contributor

Hi All- how do I group rows above in Excel Office 365 on a Mac? I don't have the "Outline" expansion button where I used to be able to toggle above/below for data grouping?

2 Replies

@slampe01 Select Data from menu bar (not the ribbon bar). Go To Data/Group and Outline/Settings... and toggle "Summary rows below detail".

,@davidcrook , what you described is a Excel functionality for Windows. For MacOS there is no such Outline/Settings option.