548 questions with Microsoft 365 and Office | Excel | For home | iOS tags
Office OpenXml files fail to open with Excel on iPad
A file created with the Open XML SDK for Office fails to open within Excel on iPad. This file successfully opens within Excel on windows, Number on iPad, and Quick Look on iPad. When opening this file in Excel on iPad, Excel pops up a "The…
Microsoft 365 and Office | Excel | For home | iOS
Edit source data for charts
Is it possible to edit the source data for charts in Excel for iPad and add category labels? In Excel for Windows you can select data cells in a sheet to create a chart, and add category labels later. For example, if I have fiscal data for country X and…
Microsoft 365 and Office | Excel | For home | iOS
What functions are currently included in Excel for iPad?
Is there a list of the included functions somewhere? The desktop Excel products have something like 342 functions.
Microsoft 365 and Office | Excel | For home | iOS
Sorting on Excel iPad app
In the desktop version of Excel I can sort using levels. For example I sort using three columns. Sort by year column, then by month column and then by member name. How do I do this in the app version?
Microsoft 365 and Office | Excel | For home | iOS
How can an .xlsm file be edited and saved
When I duplicate a read only file, and edit the resulting duplicate, the embedded macros in the duplicate are available but will not run on my desktop. How can I edit macro enabled spreadsheets on my iPad, without destroying the spreadsheet for macro…
Microsoft 365 and Office | Excel | For home | iOS
Creating a scatter chart in Excel for iPad?
I want to create a scatter chart of the attached data plotting pixels on one axis vs. size on the other. Everything I try doesn't generate the desired chart. how do I do this?
Microsoft 365 and Office | Excel | For home | iOS
excel solver on ipad
i bought Microsoft university. i am trying to use solver but there is no tools menu to enable it. does solver run on an ipad using Microsoft university in an ipad?
Microsoft 365 and Office | Excel | For home | iOS
Why does Excel for iPhone say "Can't upload—We can't merge your changes with those made by someone else"?
I've used Microsoft 365 for Mac and iOS for years. I use Excel for a spreadsheet to record twice-daily glucose and blood pressure readings to share with my doctor. I use it mostly on my iPhone, but also on my Mac; the file resides in my OneDrive account.…