Office Settings & Configuration

How to Group or Ungroup Rows in Excel for iPad

Elise WilliamsElise Williams Oct 21, 2026 870 views

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.

How to Group or Ungroup Rows in Excel for iPad
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.
Before you start

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.

Solution 1Recommended

Use the Format Menu in Excel for iPad

Utilize the built-in mobile formatting options to manage your row groups directly on your iPad.

1
Select the rows

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.

2
Access the Format menu

Tap the 'Format' icon located in the top menu ribbon of the Excel app.

3
Apply grouping

Choose 'Group' from the dropdown list, and then select 'Group Rows' to combine them, or 'Ungroup Rows' to separate them.

Use the Format Menu in Excel for iPad
Touch Selection Tip: Make sure you are tapping exactly on the row numbers to select entire rows, otherwise the grouping option may not appear correctly.
Manage Spreadsheets on Mobile

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. 1. Download WPS Office: Install WPS Office from the App Store on your iPad and open your spreadsheet document.
  2. 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. 3. Access the Tools menu: Tap the 'Tools' icon at the bottom of the screen to open the main feature panel.
  4. 4. Group the data: Navigate to the 'Data' tab within the tools panel and select 'Group' or 'Ungroup' to instantly organize your rows.
Full compatibility with Microsoft Excel (.xlsx, .xls) file formats.Consistent and feature-rich user interface across iPad, iPhone, and desktop.Advanced data management and formatting tools available for free.Lightweight application that saves valuable storage space on your device.
microsoft office alternative - wps office

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.