Office Settings & Configuration

How to Disable Focused Edit in Excel on iPad Pro

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs to disable the Focused Edit mode in Excel on an iPad Pro to restore normal editing functions like inserting and deleting rows.

Product: Microsoft Excel
Device & OS: iPadOS (iPad Pro)
Scenario: Trying to edit a spreadsheet and modify row structures on an iPad Pro, but standard editing tools are missing.
Observed behavior: Excel automatically enables Focused Edit for cells within a recognized table, hiding normal spreadsheet editing options. There is no visible Edit or Preferences button to disable this feature.

Before you start

Ensure your Excel app on the iPad Pro is updated to the latest version and verify whether the cells you are trying to edit are formatted as a Table.

Solution 1Recommended

Convert the Table to a Normal Range

By converting the table back into a standard data range, Excel disables the automated Focused Edit mode, restoring your ability to freely insert and delete rows.

Focused Edit is triggered automatically by table formatting in the iPad version of Excel. Since there is no dedicated toggle switch to turn off Focused Edit, removing the table formatting is the only way to regain full structural control over those cells.

Select a cell in the table

Tap on any cell within the data area that is currently recognized as a table to activate the table tools.

Open the Table tab

Look at the top ribbon menu in your Excel iPad app and tap on the 'Table' tab that appears.

Choose Convert to Range

Tap the 'Convert to Range' option. This removes the table behavior and immediately disables Focused Edit, allowing you to insert or delete rows normally.

Impact on Table Features: Converting to a range will remove table-specific features like automatic filtering and sorting, but your core data and cell formatting will remain intact.

Free Microsoft Office alternative

Edit Spreadsheets Seamlessly on iPad with WPS Office

If you find Excel's automatic Focused Edit mode on iPad restrictive, try WPS Office. It provides a straightforward, user-friendly interface for editing spreadsheets on mobile devices without locking essential structural edits like inserting or deleting rows behind hidden menus.

1. Download WPS Office: Install WPS Office for free from the App Store on your iPad Pro.
2. Open your spreadsheet: Launch the app and open your existing Excel (.xlsx) file directly.
3. Edit your data freely: Tap any cell and use the intuitive bottom toolbar to insert rows, delete columns, and format your data without table restrictions.

Free and lightweight mobile office suite for iPadOSFully compatible with Microsoft Excel (.xlsx, .xls) formatsIntuitive touchscreen interface for inserting and deleting rows effortlesslyNo forced editing modes that restrict basic spreadsheet operations

Frequently Asked Questions

Why does Excel on iPad hide the insert row option?

Excel automatically switches to Focused Edit mode when you select a cell within a formatted Table. This mode hides standard structural edits, such as inserting or deleting rows, to protect the table's overall layout.

Can I permanently disable Focused Edit in Excel for iPad?

No, there is no global setting or Preferences button to permanently turn off Focused Edit in the iPad app. You must convert the specific table to a range to bypass this behavior for that dataset.

How do I know if my data is in a Table in Excel for iPad?

If your data is formatted as a Table, you will see a specific 'Table' tab appear in the top ribbon menu when you tap on one of the cells. The data will also typically have banded rows and dropdown arrows for filtering.

Office App Problems