'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Create a Named Cell or Range in Excel on iPad
Question details
The user wants to define a named cell or range using the Excel mobile app on an iPad or Android device.
- Product
- Microsoft Excel
- Device & OS
- iPad, Android
- Scenario
- Attempting to manage formulas or define named ranges while working on spreadsheets on a mobile device.
- Observed behavior
- The Excel mobile app does not have the 'Define Name' command or Name Box available to create named ranges.
Ensure you have access to a desktop computer with Excel installed or a web browser to access Excel for the web, as this specific feature is currently unsupported on mobile apps.
Use Excel for Desktop or Excel for the Web
Since the mobile app lacks this feature, you must use the desktop application or the online web version of Excel to define your named ranges.
The Excel app for iPad and Android features a simplified interface that omits advanced formula tools like the Name Manager. Any named ranges you create on a desktop will still function when the file is opened on your iPad, but creating or modifying them requires the full version.
Save your iPad Excel file to OneDrive or another cloud storage service, then open the same workbook in Excel for Windows, Mac, or Excel for the web.
Click and drag to highlight the specific cell or range of cells you want to assign a name to.
Click inside the Name Box located immediately to the left of the formula bar, type your desired name (ensuring there are no spaces), and press Enter.
Edit Spreadsheets Seamlessly Across Devices with WPS Office
If you frequently encounter feature limitations in mobile apps, consider trying WPS Office. It provides a lightweight, highly compatible alternative to Microsoft Office, offering comprehensive spreadsheet tools and a familiar interface across both desktop and mobile devices.
- 1. Download and Install: Get WPS Office from the App Store on your iPad or download the desktop version from the official WPS website.
- 2. Open your Excel files: Launch WPS Office and open your existing .xlsx workbooks directly without any format conversion.
- 3. Edit and Sync: Utilize the comprehensive spreadsheet tools and save your progress to the cloud to access your work across all your devices.
Frequently Asked Questions
Can I use existing named ranges in formulas on the Excel iPad app?
Yes. If a named range was previously created on a desktop or web version of Excel, you can successfully use that name within formulas on your iPad. You simply cannot create new ones or edit existing ones directly on the mobile app.
Will the 'Define Name' feature be added to Excel for iOS and Android?
Microsoft frequently updates its mobile applications, but currently, advanced formula features like the Name Manager are restricted to the desktop and web versions. It is recommended to check the latest release notes in the App Store for future updates.
How do I find the Name Box in Excel for the web?
In Excel for the web, the Name Box is located right next to the formula bar at the top-left of your spreadsheet workspace. Select your cells, click inside this box, type the name, and press Enter to define the range.
Are there any workarounds to name a cell using only an iPad?
The primary workaround on an iPad is to open a web browser like Safari or Chrome, log into Microsoft365.com, and use the web version of Excel instead of the dedicated mobile app. The web version includes the Name Box feature.
