How to Format Data as a Table in Excel on iPad
Question details
The user wants to know the steps to convert a selected range of plain data into a formatted table using the mobile app.
- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Organizing and structuring spreadsheet data on a mobile tablet device.
- Observed behavior
- The user aims to apply table formatting to a data range to enable features like sorting, filtering, and structured styling.
Ensure your iPad has the latest version of the Microsoft Excel app installed and that your data is neatly organized in contiguous rows and columns without completely empty gaps.
Use the Insert Menu to Format as Table
The most direct way to create a table in Excel for iPad is by selecting your data and using the native Insert tab.
Applying a table format not only makes your data look professional but also automatically applies filters and allows for easier data manipulation. The iPad app interface hides some desktop ribbon tools, but the Insert Table function remains easily accessible.
Launch the Microsoft Excel app on your iPad and open the worksheet containing the data you want to format.
Tap the first cell of your data, then drag the selection handle (the circle at the corner of the selection box) to highlight the complete range of data.
Look at the ribbon menu at the top of the screen and tap the 'Insert' tab.
Tap the 'Table' option from the Insert menu. Excel will automatically apply default table formatting to your selected range.

Format Tables Easily with WPS Office for iPad
WPS Office offers a fully-featured spreadsheet application for iPad that lets you format, manage, and analyze data seamlessly. It provides an intuitive touch interface and perfect compatibility with Microsoft Excel files, making table formatting a breeze.
- 1. Open Your Spreadsheet: Launch the WPS Office app on your iPad and open your existing spreadsheet or create a new one.
- 2. Select the Target Data: Tap and drag to highlight the specific block of cells containing the data you wish to format.
- 3. Apply Table Formatting: Navigate to the 'Insert' menu on the top toolbar and tap 'Table' to automatically structure and format your data.

Frequently Asked Questions
Can I customize the table style on an iPad?
Yes, once the table is created, tap any cell inside the table to reveal the Table tab in the ribbon. From there, you can choose different table styles, change colors, and toggle options like Banded Rows or Total Row.
How do I remove the table formatting but keep the data?
To revert a table back to a standard range on your iPad, tap inside the table, go to the Table tab in the top ribbon menu, and select 'Convert to Range'. The data and cell styling will remain, but the table functionality will be removed.
Why is the Table option grayed out in Excel for iPad?
The Table option may be disabled if you have selected multiple non-contiguous ranges, if the worksheet is protected, or if you are currently actively editing a cell's text. Ensure a single continuous block of cells is selected and you are not in text-edit mode before tapping Insert.




