Numbers User Guide for iPad

Welcome


Intro to Numbers

Intro to images, graphs and other objects

Create a spreadsheet

Open spreadsheets

Prevent accidental editing

Personalise 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

Touchscreen basics

Use Apple Pencil with Numbers

Use VoiceOver to create a spreadsheet


Copyright
Use the formula keyboard in Numbers on iPad
You can use the formula keyboard to add mathematical calculations to your spreadsheet, and to choose functions from the Functions Browser.
To open the formula keyboard, tap a cell, tap at the bottom of the screen, then tap above the keyboard on the right.
Note: The layout of the formula keyboard varies on different iPad models.
To enter data with the formula keyboard, do any of the following:
Add a letter: Tap a letter key.
Add a function: If you know which function you want to enter, start typing it, then tap one of the suggestions that appear.
If you’re unsure which function you need, tap to open the Functions Browser, tap Categories at the top of the Functions Browser, then tap a function category. Tap a function to insert it in the formula editor (swipe up and down to see the available functions). To learn more about any function, tap next to it. (The first time you tap , it might take a few seconds to display the information.)
Add a number or symbol: Tap symbols in the top row of the keyboard or, to enter numbers, tap (you may need to tap , depending on your iPad model). On some models, you can drag down on a letter key until it changes to the number above the letter, then lift your finger. (For example, to enter the number 5, drag down on the T key so it changes to a 5.)
For instructions on entering formulas and functions into cells, see Insert formulas and functions in Numbers on iPad.