How to Group or Ungroup Rows in Excel for iPad
Question details
The user needs to know how to group or ungroup spreadsheet rows using the Excel application on an iPad, and requires a solution for when the grouping commands are not visible in the mobile interface.

- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Organizing and collapsing data within a spreadsheet while working on a mobile device.
- Observed behavior
- The user is trying to group rows but sometimes finds that the 'Format' or 'Group' options are unavailable or missing in the Excel Mobile app for iOS.
Ensure your Excel app on the iPad is updated to the latest version from the App Store, as older versions may lack specific formatting features.
Use the Format Menu in Excel for iPad
Utilize the built-in mobile formatting options to manage your row groups directly on your iPad.
Tap the row headers (the numbers on the left side of the screen) and drag the selection handle to highlight all the rows you want to group or ungroup.
Tap the 'Format' icon located in the top menu ribbon of the Excel app.
Choose 'Group' from the dropdown list, and then select 'Group Rows' to combine them, or 'Ungroup Rows' to separate them.

Modify Grouping in Desktop Excel
If the grouping features are missing in your Excel Mobile app, use the desktop version as a reliable alternative to organize your data.
Easily Group and Ungroup Rows with WPS Office
If you find mobile spreadsheet management frustrating, WPS Office provides a robust set of tools on both mobile and desktop. You can easily group or ungroup rows natively on your iPad without worrying about missing features.
- 1. Download WPS Office: Install WPS Office from the App Store on your iPad and open your spreadsheet document.
- 2. Select the rows: Tap the row headers on the left side of the screen to select the range of rows you wish to group.
- 3. Access the Tools menu: Tap the 'Tools' icon at the bottom of the screen to open the main feature panel.
- 4. Group the data: Navigate to the 'Data' tab within the tools panel and select 'Group' or 'Ungroup' to instantly organize your rows.

Frequently Asked Questions
Why is the Format or Group button missing in my Excel app for iPad?
The Excel app for iOS does not contain all the features found in the desktop version. Depending on your device size, Microsoft 365 subscription tier, or the app version, certain advanced formatting tools like row grouping may be hidden or entirely unsupported.
Can I group columns in Excel for iPad the same way as rows?
Yes, if the grouping feature is available in your app version, you can tap and drag the alphabetical column headers to select them, tap Format, choose Group, and then select Group Columns.
Will grouping rows on an iPad sync to my desktop Excel?
Yes. As long as your workbook is saved to a cloud service like OneDrive or SharePoint, any row groups you create or remove on your iPad will automatically sync and be fully functional when you open the file on your desktop.
How do I easily select multiple rows on the iPad touch interface?
Tap the first row number header to select it, then grab the circular selection handle that appears at the corner of the highlight box and drag it down to encompass all the rows you want to include in your group.




