'%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 Reference Named Tables in Excel Mobile on iPad
Question details
The user needs to reference or manage named tables in Excel Mobile on an iPad but is unable to locate the necessary naming features.
- Product
- Microsoft Excel
- Device & OS
- iPad
- Scenario
- Attempting to create, rename, or reference named tables and ranges while editing a spreadsheet on an iPad.
- Observed behavior
- Excel Mobile for iPad does not include the Table Name box or the full Name Manager functionality found in the desktop version.
Ensure you have access to a desktop computer with Microsoft Excel installed or access to Excel for the Web, as the iPad application has feature limitations.
Use Desktop Excel to Manage Named Tables
Since the iPad app lacks the Name Manager, the most reliable method is to configure your named tables on a desktop computer first.
Excel Mobile on iPad does not support creating or renaming tables directly through a Table Name box.
By preparing your workbook on a desktop, your existing named tables will continue to function properly when later opened on the iPad.
Launch Microsoft Excel on your Windows PC or Mac and open the workbook you want to edit.
Click on any cell inside your table, navigate to the Table Design tab on the ribbon, and type your desired name into the Table Name box on the far left.
Save your workbook to OneDrive, iCloud, or another cloud storage service accessible from your iPad.
Launch Excel Mobile on your iPad and open the recently saved cloud document. The named table references will now be active in your formulas.
Use Standard Cell References Instead of Names
If you must build formulas entirely on the iPad, bypass the missing named tables feature by using standard cell range references.
Edit Using Excel for the Web on iPad
Use the browser-based version of Excel to access features that are missing from the standalone iPad application.
Try WPS Office for Seamless Spreadsheet Management
If feature limitations in Microsoft Excel for iPad disrupt your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative that ensures you can view, edit, and manage your spreadsheets efficiently across all mobile and desktop devices.
- 1. Download the App: Search for WPS Office in the Apple App Store on your iPad and download it for free.
- 2. Open Your Spreadsheets: Import your existing .xlsx files directly into WPS Office without losing any data.
- 3. Edit Without Limits: Enjoy robust mobile spreadsheet editing, formula support, and seamless document management.
Frequently Asked Questions
Does Excel for iPad have a Name Manager?
No, Excel Mobile for iPad currently does not feature a Name Manager. You cannot create, edit, or delete named ranges and tables natively within the app. You must rely on the desktop version to handle these tasks.
Can I rename an existing table directly on my iPad?
No, the Table Name box is not available on the iPad app ribbon. To rename a table, you need to open your workbook in Excel on a Windows PC or Mac.
Will formulas with named tables still work on the iPad app?
Yes. Even though you cannot create or manage named tables on the iPad, any existing formulas that reference previously created named tables will calculate and function correctly when you open the file.
