Table of Contents

• Welcome
• What’s new in Numbers for iCloud
• Numbers basics
  • Intro to Numbers for iCloud
  • Intro to tables and other objects
  • Create a spreadsheet
  • Organize with sheets
  • Change the sheet background
  • Upload a spreadsheet
  • Sync a spreadsheet
  • Print a spreadsheet
  • Change the spreadsheet view
  • 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
  • Change an existing formula
  • Add checkboxes and other controls
  • Clear cell content and formatting
  • Format as currency or other data
  • Use Formulas and Functions Help
• Sort, filter, and organize tables
  • Alphabetize or sort data
  • Filter data
  • Organize data into categories
    • Intro to categories
    • Add or edit categories
    • Edit groups in a categorized table
    • 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 and grouped
    • Refresh a pivot table
    • View the source data for a value
• Add charts
  • Create 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
  • Select text
  • Copy and paste text
  • Add bulleted or numbered lists
  • Format text and characters
    • Change the font, size, style, or color of text
    • Apply preset paragraph styles in Numbers for iCloud
    • 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, phone number, or sheet
  • Work in other languages
    • Write in another language
    • Change the text direction
    • Create a spreadsheet with the formatting of a different language
• Add images, shapes, and media
  • Images
    • Add or replace images
    • Add an image gallery
    • Crop (mask) an image
  • Shapes and lines
    • Add shapes and lines
    • Edit shapes and lines
    • Combine or break apart shapes
    • Add text inside a shape
  • Add video and audio
• 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 shapes and text boxes with colors or images
• Share and collaborate
  • Email a spreadsheet
  • 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
• Manage spreadsheets
  • Save, name, or duplicate spreadsheets
  • Delete or recover spreadsheets
  • 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
• Legal notices and acknowledgements
• Copyright