How to Create Pivot Tables on Mobile (2026) | Full Guide, by Tutorial vx on YouTube. 2 min 22 s.
- Video length
- 2 min 22 s
- Time to do it
- 10 minutes
- Difficulty
- Easy
- Steps
- 9
What you need
Steps
Install the Microsoft Excel app from the Play Store or App Store, open it and sign in with your Microsoft account. Open the workbook that holds your data.
Tap any single cell inside your data range. Make sure the range has one header row, no blank rows or columns, and no merged cells.
Tap the edit or ribbon button at the bottom of the screen to open the tabs, then tap Insert and choose Pivot Table.
Check the range Excel fills in for you. Drag the handles if it picked the wrong cells, then tap OK or Done.
Choose New Sheet to place the pivot table, or pick an existing sheet. The empty pivot table and the fields pane open.
Tap or drag field names into the Rows, Columns, Values and Filters boxes to lay out your summary. Text fields work best in Rows.
Tap the field you dropped in Values and set Summarize by to Sum, Count or Average, depending on what your numbers mean.
Tap Done or the checkmark, then close the fields pane to see the finished table. Tap any cell in it to reopen the pane and change the layout.
Leave the file to save itself to OneDrive. If you edit the source data later, reopen the pivot table and tap the refresh icon.
Tips and common mistakes
Tap inside the data before you open the Insert tab, or Pivot Table may stay greyed out.
Give every column a short, unique header and remove totals rows from the source, or the pivot table will count them as data.
Excel guesses Sum for number fields and Count for text fields, so check the Values box before you share the sheet.
The free mobile app can create and edit pivot tables, but some advanced options such as calculated fields need a desktop browser.
Questions
Can I make a pivot table in the free Excel mobile app?
Yes. Creating and editing basic pivot tables is free in the Excel app on Android and iPhone. A Microsoft 365 subscription only adds advanced options like calculated fields and slicers.
How do I update the pivot table after changing my data?
Tap a cell inside the pivot table, open the fields pane and tap the refresh icon. The table then rereads your source range and updates the totals.
Does the Google Sheets app work the same way?
No. The Google Sheets mobile app does not let you create pivot tables. Open the sheet in a desktop browser and use Insert, then Pivot table instead.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
