Apple
Mac
iPad
iPhone
Watch
Support
Where to Buy
Numbers User Guide for iCloud
Open Menu
Close Menu
Communities
Contact Support
Table of Contents
Welcome
Numbers basics
Intro to Numbers for iCloud
Intro to tables and other objects
Create your first spreadsheet
Organize with sheets
Change the sheet background
Upload a spreadsheet
Sync a spreadsheet
Print a spreadsheet
Change the spreadsheet view
Choose a language
Troubleshooting
If you can’t find a spreadsheet
Resolve spreadsheet conflicts
Add and style tables
Add or delete tables
Select cells, rows, columns, or tables
Add or change rows and columns
Merge and unmerge cells
Change the look of text, rows, and borders
Change the look of table text
Change table gridlines and colors
Format tables for bidirectional text
Add table data and formulas
Enter text and numbers
Add formulas and functions
Intro to formulas and functions
Add calculations
Change an existing formula
Arguments and values
String operators and wildcards
Add checkboxes and other controls
Clear cells
Format as currency or other data
Sort, filter, and organize tables
Alphabetize or sort data
Filter data in a table
Organize data into categories
Intro to categories
Add or edit categories
Edit groups in a categorized table
Summarize group data
Create and modify charts
Add or delete a chart
Edit chart data
Edit chart text and markings
Change how data is displayed
Change the chart background
Change a chart’s type
Add text
Add text to a spreadsheet
Copy and paste text
Add bulleted or numbered lists
Format text and characters
Change the font, size, style, or color of text
Add drop caps
Raise and lower text
Add a shadow to text
Change text capitalization
Align and space text
Adjust alignment and spacing
Format columns of text
Adjust character spacing
Add borders and rules (lines)
Add a background color to text
Link to a website, email, or sheet
Write in other languages
Add images and shapes
Add or replace images
Add an image gallery
Crop (mask) an image
Add shapes and lines
Edit shapes and lines
Combine shapes
Add text inside a shape
Position and style objects
Position objects on a sheet
Move and align objects
Resize objects
Rotate or flip objects
Connect objects with a line
Place objects inside a text box or shape
Layer, group, and lock objects
Customize the look of objects
Add a title or caption
Apply object styles
Fill objects with color or an image
Share and collaborate
Collaborate with others
Intro to collaboration
Invite others to collaborate
Collaborate on a spreadsheet
Change shared spreadsheet settings
Stop sharing spreadsheets
Shared folders and collaboration
Use Box to collaborate
Email a spreadsheet
Manage spreadsheets
Save, name, or duplicate spreadsheets
Delete a spreadsheet
Restore earlier versions
Organize spreadsheets
Password-protect spreadsheets
Download spreadsheets
Writing and editing tools
Spell-check text
Find and replace text
Add or reply to comments
Set your author name and color
Keyboard shortcuts