Forum Discussion

evanzarate's avatar
evanzarate
Copper Contributor
Jan 24, 2024

How to Change Group Direction

I am looking to change the group direction for some rows I have grouped from below to above. In the desktop version of excel I know you can expand the group function and go into its settings and select/deselect "summary of group below detail". Where is that for the excel application in sharepoint?

  • Excel for the Web does not offer the same level of control for group direction as the desktop version. Ungroup and regroup to adjust the arrangement as a workaround. Use Excel Desktop for more advanced grouping options, then save and upload back to SharePoint.

Resources