Formatting Issues

How to Format Data as a Table in Excel on iPad

Amos GikundaAmos Gikunda Oct 19, 2026 872 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Workbook

Launch the Microsoft Excel app on your iPad and open the worksheet containing the data you want to format.

2
Select the Data Range

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.

3
Navigate to the Insert Tab

Look at the ribbon menu at the top of the screen and tap the 'Insert' tab.

4
Insert the Table

Tap the 'Table' option from the Insert menu. Excel will automatically apply default table formatting to your selected range.

Use the Insert Menu to Format as Table
Formatting Complete: Your data is now formatted as a table, and you will see drop-down arrows in the header row for immediate sorting and filtering.
WPS Spreadsheet for iPad

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. 1. Open Your Spreadsheet: Launch the WPS Office app on your iPad and open your existing spreadsheet or create a new one.
  2. 2. Select the Target Data: Tap and drag to highlight the specific block of cells containing the data you wish to format.
  3. 3. Apply Table Formatting: Navigate to the 'Insert' menu on the top toolbar and tap 'Table' to automatically structure and format your data.
100% compatible with Microsoft Excel (.xlsx, .xls) formats.Lightweight app with a user-friendly touch interface optimized for iPad.Rich built-in formatting tools for tables, charts, and mobile data analysis.Free to download and use for essential spreadsheet tasks.
microsoft office alternative - wps office

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.