Forum Discussion

slampe01's avatar
slampe01
Copper Contributor
Jan 23, 2020

How to group rows above Excel Office 365 on Mac

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?

  • davidcrook's avatar
    davidcrook
    Copper Contributor

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

    • rvcavaleiro's avatar
      rvcavaleiro
      Copper Contributor

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

Resources