Function Problems

Are Named Ranges Available in Excel for iPad?

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to know if they can create and manage named ranges in the Excel app on an iPad.

Product: Microsoft Excel
Device & OS: iPadOS
Scenario: Editing an Excel workbook on an iPad and attempting to define, edit, or manage named ranges for formulas.
Observed behavior: Excel for iPad currently does not support the native creation or management of named ranges directly within the application.

Before you start

Ensure you have access to a desktop computer or a web browser, as you will need the web or desktop version of Excel to manage named ranges.

Solution 1Recommended

Use Excel for Web or Desktop to Manage Named Ranges

Since the iPad app lacks this feature, you can use the desktop or web version of Excel to set up your named ranges, which will then function correctly when viewing the file on your iPad.

While you cannot create or edit named ranges directly on the iPad, any named range created on the desktop or web versions will still work in your formulas when the file is opened on your mobile device.

Save your workbook to the cloud

Ensure your Excel file is saved to OneDrive or SharePoint so it can be seamlessly accessed across different devices.

Open Excel on a desktop or web browser

Log in to Microsoft 365 on a computer and open your spreadsheet in Excel for the Web or the full Excel desktop application.

Create or edit the named range

Navigate to the 'Formulas' tab and click on 'Name Manager' (or 'Define Name') to create and manage your named ranges.

Access the updated file on your iPad

Once your changes are saved, open the file again on your iPad. The newly defined named ranges will now be recognized and functional in your existing formulas.

Submit Feature Request: If you need native support for this feature on iPad, you can submit feedback directly through Microsoft's Feedback Portal to request named-range functionality in future updates.

Free Microsoft Office alternative

Try WPS Office for Your Mobile Spreadsheet Needs

If you find Microsoft Excel for iPad lacking in features or too restrictive, WPS Office offers a comprehensive, free, and lightweight alternative. It provides excellent compatibility with Microsoft Office formats and an intuitive interface designed for mobile productivity.

1. Download WPS Office: Get WPS Office for free from the App Store on your iPad.
2. Open your spreadsheet: Launch the app and open your existing .xlsx file directly without losing formatting.
3. Manage data effortlessly: Use the built-in spreadsheet tools tailored for mobile efficiency and productivity.

Highly compatible with Microsoft Excel (.xlsx) formats.Rich formula support and advanced spreadsheet tools on mobile devices.Lightweight application that saves storage space on your iPad.Free to download and use with familiar user interfaces.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use existing named ranges in Excel for iPad?

Yes. While you cannot create or edit named ranges directly within the Excel for iPad app, any named ranges previously defined on a desktop or web version will continue to work normally in your formulas on the iPad.

How can I tell Microsoft I want this feature on iPad?

Microsoft continually updates its mobile apps based on user feedback. You can vote for or request this feature via the Microsoft Feedback Portal to encourage its development.

Are there any workarounds to define named ranges entirely on an iPad?

The most reliable workaround is opening Safari or another web browser on your iPad, logging into Microsoft 365 online, and using Excel for the Web to define the named ranges there instead of using the native app.

Excel & Data Problems