'%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 PivotTable in Excel for iPad
Question details
The user wants to know if it is possible to create a new PivotTable using the Microsoft Excel application on an iPad.
- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Attempting to summarize and analyze data by inserting a PivotTable while working within a spreadsheet on an iPad.
- Observed behavior
- The Excel mobile app for iPad does not currently support the feature to create new PivotTables, restricting data analysis capabilities on the device.
Ensure your iPad has a stable internet connection and you have your Microsoft account credentials ready, as the best workaround involves using a web browser.
Use Excel for the Web via iPad Browser
Bypass the mobile app limitations by accessing the web-based version of Excel directly from your iPad's browser.
While the native Excel app for iPad restricts the creation of new PivotTables, the full web version of Excel includes this functionality. By using a browser like Safari, you can access the necessary tools without needing a desktop computer.
Launch Safari, Chrome, or your preferred web browser on your iPad.
Go to Office.com and sign in using your Microsoft account credentials.
Select the Excel icon from the online dashboard and open the workbook you want to edit.
Highlight your data range, tap the 'Insert' tab on the web ribbon, and select 'PivotTable' to create it.
Switch to a Desktop Version of Excel
Use a Windows or Mac computer to create the PivotTable for full data analysis functionality.
Analyze Data Without Limits Using WPS Office
Don't let mobile app limitations slow down your productivity. WPS Office offers a powerful, lightweight, and free alternative to Microsoft Office, ensuring you can seamlessly manage, analyze, and pivot your data across all your desktop devices.
- 1. Download WPS Office: Install WPS Office for free from the official website onto your PC or Mac.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and easily open your existing Excel workbooks.
- 3. Insert PivotTable: Select your data, navigate to the Insert tab, and click PivotTable to begin analyzing instantly.
Frequently Asked Questions
Can I edit an existing PivotTable in the Excel app for iPad?
Yes. While you cannot create a new PivotTable from scratch on the iPad app, you are able to interact with existing ones. You can expand or collapse data, filter, sort, and refresh the PivotTable directly in the app.
Will Microsoft ever add PivotTable creation to the iPad app?
Microsoft regularly updates its mobile applications based on user demand. You can encourage the development of this feature by submitting a request through the Help & Feedback section inside the Excel app or via Microsoft's feedback portal.
Does Excel for iPhone support creating PivotTables?
No, similar to the iPad application, the Excel app for iPhone does not currently support creating new PivotTables. You must use Excel for the web or a desktop version to initiate a new PivotTable.
