Excel Online Server Row and Column Groups: What Works and How to Create Them
Question details
The user wants to know whether Excel Online Server can create new row and column groups and how to work with existing outline groups in the browser.
- Product
- Excel Online Server / Office Online Server
- Device & OS
- not provided
- Scenario
- A user needs to create or edit row and column groups in a workbook opened in Excel Online Server.
- Observed behavior
- Existing outline groups may be displayed, but the browser interface may not provide a reliable command for creating new row or column groups.
Confirm whether your workbook already contains outline groups and identify the exact rows or columns you need to group. If you are using Excel Online Server, also make sure you can open the same file in a desktop version of Excel or WPS Spreadsheets.
Create Groups in Desktop Excel and Reopen the Workbook in Excel Online Server
Use this when Excel Online Server displays existing groups but does not provide a Create Group command, or when you need to reliably add row or column groups.
Excel Online Server and older Office Online Server versions may display outline groups that were already created, but they may not expose the Data > Group command in the browser. The most reliable workflow is to create the grouping in a desktop spreadsheet application and then reopen the file.
Open the workbook in the desktop version of Microsoft Excel on a computer that has access to the file.
Select the exact rows or columns that you want to include in the outline group.
Click the Data tab, choose Group, and then select Rows or Columns to create the group.
Save the workbook, upload or sync it to the server location, and open it again in Excel Online Server.
Click the plus, minus, or numbered outline symbols to expand or collapse the group in the browser.
Review Existing Groups in Excel Online Server
Use this when you only need to expand, collapse, or inspect outline groups that are already present in an uploaded workbook.
Create and Edit Row and Column Groups in WPS Spreadsheets
WPS Spreadsheets gives you a free, lightweight, and familiar way to create, edit, expand, and collapse row and column groups locally. It opens and saves .xlsx files, so you can work with Excel workbooks and still share them back to Excel Online Server or Excel desktop without losing outline groups.
Frequently Asked Questions
Can Excel Online Server create new row and column groups?
In many versions it can display existing outline groups but cannot reliably create new ones. Use desktop Excel or WPS Spreadsheets to create the groups, then reopen the file in Excel Online Server.
How do I create a row group so Excel Online Server can display it?
Open the workbook in desktop Excel, select the rows, click Data > Group, save the file, and reopen it in Excel Online Server. The group should then appear with expand/collapse controls.
Why can I see group expand/collapse buttons but not add another group in Excel Online Server?
The server version may be an older Office Online Server build or the administrator may have disabled editing features. Check the server version and use a desktop spreadsheet application for editing.
Can WPS Spreadsheets create groups in an Excel file?
Yes. WPS Spreadsheets supports .xlsx workbooks and has a Data > Group command for row and column groups. You can save the file as .xlsx and open it in Excel Online Server or Microsoft Excel.
Do I need Microsoft Excel desktop if I use WPS Office?
No. WPS Spreadsheets can create and edit row and column groups directly, so you can avoid the Excel Online Server limitation without purchasing Excel desktop.
