Numbers User Guide for Mac

• Welcome
• Numbers basics
  • Intro to Numbers
  • Intro to images, graphs and other objects
  • Create a spreadsheet
  • Open or close spreadsheets
  • Personalise templates
  • Use sheets
  • Undo or redo changes
  • Save your spreadsheet
  • Find a spreadsheet
  • Delete a spreadsheet
  • Print a spreadsheet
  • Change the sheet background
  • Customise your app
    • Change the spreadsheet view
    • Customise the toolbar
    • Show or hide the sidebar
    • Set preferences
    • Set a default template
  • Touch Bar for Numbers
  • Use VoiceOver to create a spreadsheet
• 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 un-merge cells
  • Change how a table looks
    • Change how table text looks
    • Show, hide or edit a table title
    • Change table grid colours
    • Use table styles
  • Resize, move or lock a table
• Add and organise table content
  • Add text and objects to cells
    • Add text to tables
    • Add objects to cells
    • Add stock information
    • Auto fill cells
    • Copy, move or delete cell content
  • Work with different types of data
    • Format dates, currency and more
    • Create a custom cell format
    • Add tick boxes and other controls to cells
    • Format tables for bidirectional text
  • Wrap text to fit in a cell
  • Highlight cells
  • Filter data
  • Alphabetise or sort data in a table
  • Organise data into categories
    • Intro to categories
    • Add, edit or delete categories
    • Change category groups
    • Add calculations to summarise group data
• Enter formulas and functions
  • Quickly calculate a sum, average and more
  • Insert formulas and functions
  • Types of arguments and values
  • String operator and wildcards in formulas
    • Use string operators and wildcards
    • Functions that accept conditions and wildcards as arguments
• Create and modify graphs
  • Add or delete a graph
    • Select data to make a graph
    • Column, bar, line and area graphs, pie and doughnut charts
    • Add scatter plots and bubble charts
    • Interactive graphs
    • Delete a graph
    • Change a graph’s type
  • Modify graph data
  • Move and resize graphs
  • Change the look of a graph
    • Change the look of data series
    • Add graph labels
    • Change graph labels
    • Add a graph border and background
    • Use graph styles
• Add, edit and format text
  • Select text and place the insertion point
  • Add and edit text
    • Add text
    • Copy and paste text
    • Use dictation to enter text
    • Use accents and special characters
    • 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
    • Change the font or font size
    • Bold, italic, underline and strikethrough
    • Change the colour of text
    • Change text capitalisation
    • Add a shadow or outline to text
  • Use paragraph styles
    • Intro to paragraph styles
    • Apply a paragraph style
    • Create, rename or delete paragraph styles
    • Update or revert a paragraph style
  • Use a keyboard shortcut to apply a style
  • Format characters and punctuation
    • Adjust character spacing
    • Add drop caps
    • Raise and lower characters and text
    • Format fractions automatically
    • Create and use character styles
    • 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 a highlighting effect to text
  • Link to a webpage, email or sheet in Numbers on Mac
  • Add 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
    • Draw a shape
    • Save a shape to the shapes library
    • Add and align text inside a shape
  • Add lines and arrows
  • Animate, share or save drawings
  • Video and audio
    • Add video and audio
    • Record audio
    • Edit video and audio
  • Set movie and image formats
• Position and style objects
  • Position objects on a sheet
    • Use rulers
    • Position and align objects
    • Use alignment guides
    • Place objects inside a text box or shape
    • Layer, group and lock objects
  • Change object transparency
  • Fill objects with colour 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 author name and comment colour
  • Highlight text
  • Add and print comments
• Share and collaborate
  • Send a spreadsheet
  • Intro to collaboration
  • Invite others to collaborate
  • Collaborate on a shared spreadsheet
  • Change a shared spreadsheet’s settings
  • Stop sharing a spreadsheet
  • Shared folders and collaboration
  • Use Box to collaborate
• Manage and organise spreadsheet files
  • Use iCloud with Numbers
  • Import an Excel or text file
  • Export to Excel or another file format
  • Reduce the spreadsheet file size
  • Save a large spreadsheet as a package file
  • Restore an earlier version of a spreadsheet
  • Move a spreadsheet
  • Lock 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