Excel for Android Name Manager Availability for Defined Names
Question details
The user wants to know whether the Name Manager is available in Excel for Android for creating or editing defined names and named formulas.

- Product
- Microsoft Excel for Android
- Device & OS
- Android
- Scenario
- The user needs to manage defined names or LAMBDA functions in an Excel workbook from an Android device.
- Observed behavior
- Excel for Android can open and calculate supported workbooks that contain defined names, but it generally does not provide the full Name Manager interface.
Make sure the workbook is saved to a location that can be opened on both your mobile device and a desktop computer. Check that the formulas and named ranges are supported by the version of Excel you plan to use on Android.
Create or edit names in Excel for Windows or Mac
Use the desktop Excel app when you need to add, modify, delete, or review defined names and named LAMBDA formulas.
The full Name Manager is generally unavailable in Excel for Android. Create or update workbook names in Excel for Windows or Mac, save the file, and then open it on Android for viewing and supported calculations.
Open the workbook in Microsoft Excel for Windows or Mac.
Select the Formulas tab on the ribbon, then choose Name Manager.
In Name Manager, select New to create a name or select an existing name and choose Edit. For a named LAMBDA, enter the LAMBDA formula in the Refers to box.
Save the workbook, then open the same file in Excel for Android. The app can use supported defined names and formulas even though it does not offer the full Name Manager screen.

Use Excel for the web for basic workbook access
Use Excel for the web when a desktop app is not available, while keeping in mind that its name-management features may also be more limited than desktop Excel.
Work with Excel Workbooks Easily in WPS Office
WPS Office is a free, lightweight office suite with a familiar spreadsheet interface and strong Microsoft Excel format compatibility. It helps you open, review, and continue working with Excel workbooks across devices while making migration from Microsoft Office straightforward.

Frequently Asked Questions
Can Excel for Android use named ranges in a workbook?
Yes. Excel for Android can generally open workbooks that already contain defined names and can calculate supported formulas that refer to those names.
How do I create a named range for use on an Android phone?
Open the workbook in Excel for Windows or Mac, go to Formulas > Name Manager > New, create the name, save the workbook, and then reopen it in Excel for Android.
Can I edit a named LAMBDA function in Excel for Android?
Generally, no. Edit the named LAMBDA in desktop Excel through Formulas > Name Manager, then save the workbook for use on Android.
Why is Name Manager missing from the Excel Android ribbon?
Excel for Android has a reduced feature set compared with the Windows and Mac desktop applications. Full defined-name management is one of the features that is typically limited to desktop Excel.




