Numbers makes it easy to make compelling spreadsheets. You start with a template, then modify it however you like. The templates are designed for specific purposes—like budgets and checklists—to give you a great starting point for your work. Each template comes with predesigned styles for text, tables, shapes, and other objects that all look good together, so it’s easy to give your spreadsheet a coordinated appearance.
After you open a template, you can add your own numbers, formulas, dates, and text to any table; replace or delete charts and graphics; and add new tables, charts, and more.
When you select an object (an image, shape, chart, table, or cell), then tap the paintbrush, you see formatting controls for the type of object you selected.
You can quickly change the look of the selected object by tapping a style to apply it. You can also swipe up from the bottom of the formatting controls to see more options for customizing the object.
Gestures are critical when using Numbers on your iOS device. These are the gestures you need to know:
Using one finger, quickly and firmly touch the screen, then lift your finger. Use this gesture to select an object or activate a button.
You can drag to move an object, or to resize an object or selection range.
To move an object, touch and hold the object, then drag it to where you want it. To resize an object, tap it, touch and hold one of the selection handles, then drag to resize.
Select multiple objects
Select as many objects as you want by touching and holding one object on the screen, then tapping the other objects with another finger. Use both hands if it’s easier.
Pinch open to zoom in
Place two fingers on the screen and spread them apart. This allows you to see a close-up of items on the screen. If you’re beginning with the sheet size at 100 percent in Numbers (the normal view), pinch open quickly to immediately increase the sheet size up to 150 or 200 percent. If you want an in-between size, pinch open more slowly. An indicator shows you the current magnification level as you pinch.
Pinch closed to zoom out
Place two fingers on the screen and bring them together. This allows you to see more items on the screen. If you’re beginning with the sheet size at 100 percent in Numbers (the normal view), pinch closed quickly to decrease the sheet size to 50 percent. If you want an in-between size, pinch closed more slowly. An indicator displays the current magnification level as you pinch.
Scroll, swipe, flick
Scroll slowly by sliding one finger up and down or side to side on the screen. Scroll quickly (swipe or flick) by whisking one finger rapidly across the screen. Scrolling allows you to see more rows and columns in a table, any items that are currently beyond the edges of the screen, or more options and controls within a window.
Any header rows or columns in your table are frozen by default. This means that they stay put as you scroll within the body of the table.
Create a Spreadsheet
To create a spreadsheet, you start with either a blank template, to which you can add tables, charts, text, and other objects, or a predesigned template that has placeholder elements, including text and images. These templates, which are designed for purposes like personal finance, business, and education, give you a great starting point, and you can modify them however you like.
In the spreadsheet manager, tap "+" at the top of the screen to open the template chooser.
Tap a spreadsheet template.
Scroll to see all of the templates, or tap a category at the top.
Do any of the following to customize your spreadsheet:
Tap a table cell to delete placeholder content and add your own.
Tap in the toolbar to add other tables, text boxes, shapes, and images.
Arrange the sheet by dragging tables and objects to where you want them.
Your spreadsheet is saved automatically as you work. You can change the name of the spreadsheet or change where it's saved at any time.
For more information on Numbers, such as usign formulas and adding images, please see the Apple Support Guide below:
K-2 Using Numbers
The iPad offers many built in Accessibility tools that allow every student in your classroom to feel empowered and engaged. Here are a few ways you can reach all learners using these Accessibility Tools in your classroom:
Teachers can use the Numbers app to create Infographics for struggling readers. Adding pictures to text will support more learners in your class.
Students can use Dictation to fill in cell information as well as to create comments and text boxes. Speak selection can be used to listen to text already on sheets and forms created with Numbers.