Numbers Search this guide Clear Search Table of Contents
Numbers User Guide for iPad
Welcome
What’s new
Numbers basics
Get started with Numbers
Intro to images, charts, and other objects
Create a spreadsheet
Open spreadsheets
Prevent accidental editing
Personalize templates
Use sheets
Undo or redo changes
Save your spreadsheet
Find a spreadsheet
Delete a spreadsheet
Print a spreadsheet
Change the sheet background
Copy text and objects between apps
Customize the toolbar
Touchscreen basics
Use Apple Pencil with Numbers
Use VoiceOver with Numbers
Use VoiceOver to create a spreadsheet
Use VoiceOver to create formulas and autofill cells
Add and style tables
Add or delete a table
Select cells, rows, and columns
Add or change rows and columns
Add or remove rows and columns
Move rows and columns
Resize rows and columns
Merge or unmerge cells
Change how a table looks
Change how table text looks
Show, hide, or edit a table title
Change table grid colors
Use table styles
Resize, move, or lock a table
Add and organize table content
Add text and objects to cells
Add text to tables
Enter data using forms
Add objects to cells
Add stock information
Add a date, time, or duration
Autofill cells
Copy, move, or delete cell content
Create a snapshot of a table
Work with different types of data
Format dates, currency, and more
Add checkboxes and other controls to cells
Format tables for bidirectional text
Wrap text to fit in a cell
Highlight cells
Alphabetize or sort data in a table
Filter data
Organize data into categories
Intro to categories
Add, edit, or delete categories
Change category groups
Add calculations to summarize group data
Create pivot tables
Intro to pivot tables
Create a pivot table
Add and arrange pivot table data
Change how pivot table data is sorted, grouped, and more
Refresh a pivot table
View the source data for a pivot table value
Enter formulas and functions
Quickly calculate a sum, average, and more
Use the formula keyboard
Calculate values using data in table cells
Copy and paste formulas
Use the Formulas and Functions Help
Create and modify charts
Add or delete a chart
Select data to make a chart
Add column, bar, line, area, pie, donut, and radar charts
Add scatter and bubble charts
Interactive charts
Delete a chart
Change a chart’s type
Modify chart data
Move and resize charts
Change the look of a chart
Change the look of data series
Add a legend, gridlines, and other markings
Change the look of chart text and labels
Add a chart border and background
Use chart styles
Add, edit, and format text
Select text
Add and edit text
Add text
Copy and paste text
Enter text in another language
Format a spreadsheet for another language
Use phonetic guides
Use bidirectional text
Use vertical text
Change the look of text
Use text styles
Format characters and punctuation
Change text capitalization
Add drop caps
Ligatures
Make characters superscript or subscript
Format fractions automatically
Format dashes and quotation marks
Format Chinese, Japanese, or Korean text
Align and space text
Set tab stops
Align text
Format text into columns
Adjust line spacing
Format lists
Add and edit equations
Add links
Add borders and rules (lines) to separate text
Add images, shapes, and media
Images
Add an image
Add an image gallery
Edit an image
Shapes
Add and edit a shape
Combine or break apart shapes
Save a shape to the shapes library
Add and align text inside a shape
Add 3D objects
Add lines and arrows
Add and edit drawings
Video and audio
Add video and audio
Record video and audio
Edit video and audio
Set the movie and image formats
Position and style objects
Position objects on a sheet
Position and align objects
Use alignment guides
Place objects inside a text box or shape
Layer, group, and lock objects
Change object transparency
Fill shapes and text boxes with color or an image
Add a border to an object or sheet
Add a caption or title
Add a reflection or shadow
Use object styles
Resize, rotate, and flip objects
Use writing and editing tools
Look up words
Find and replace text
Replace text automatically
Check spelling
Set your author name for comments
Highlight text
Add and print comments
Share and collaborate
Send a spreadsheet
Intro to collaboration
Invite others to collaborate
Collaborate on a shared spreadsheet
See the latest activity in a shared spreadsheet
Change a shared spreadsheet’s settings
Stop sharing a spreadsheet
Shared folders and collaboration
Use Box to collaborate
Manage and organize spreadsheet files
Use iCloud with Numbers
Import an Excel or text file
Export to Excel or another file format
Restore an earlier version of a spreadsheet
Move a spreadsheet
Password-protect a spreadsheet
Create and manage custom templates
Transfer spreadsheets between devices
Transfer spreadsheets with AirDrop
Transfer spreadsheets with Handoff
Transfer spreadsheets with the Finder
Keyboard shortcuts
Keyboard shortcuts
Keyboard shortcut symbols
Copyright
If you make changes to the source data for a pivot table, you need to refresh the pivot table to see the changes reflected.
Go to the Numbers app on your iPad.
Open a spreadsheet, then select the pivot table you want to refresh.
Tap , tap next to Source Data, then tap .
You can also see when the pivot table was last refreshed.
See alsoIntro to pivot tables in Numbers on iPadCreate a pivot table in Numbers on iPadAdd and arrange pivot table data in Numbers on iPadChange how pivot table data is sorted, grouped, and more in Numbers on iPadCreate a snapshot of a table in Numbers on iPadFilter data in Numbers on iPad
on your iPad.
, tap 
next to Source Data, then tap 
.