What’s new in Pages, Numbers and Keynote.

We’re constantly updating Pages, Numbers and Keynote. So your favourite productivity apps keep getting more productive — whether you’re working on an iOS device, on a Mac or in iCloud. To help you keep up with the latest improvements, we’ve listed them all right here.

Numbers for iOS

Editing

  • View and restore changes made to a document over time
  • Instantly rearrange data in tables with new Transpose feature

Charting

  • Add reference lines to charts
  • Chart date and duration values
  • Control the z-order of bubble chart labels
  • Custom number formats in charts are preserved on import of Numbers ’09 and Microsoft Excel spreadsheets

Design tools

  • Take photos and videos without leaving the app
  • More colours to choose from
  • New custom colour mixer on iPad
  • Use the colour picker to sample any colour in your spreadsheet and apply it anywhere

Sharing

  • Preview shared documents on iOS and Android browsers
  • “View only” setting lets you share spreadsheets you want others to view but not edit
  • Share password-protected spreadsheets via iCloud link
  • Support for iCloud Drive
  • Support for third-party storage providers

Microsoft Excel compatibility

  • Improved Excel compatibility for charts, text overflows and nonrectangular masks
  • Export password-protected spreadsheets to XLSX format
  • Improved compatibility with Microsoft Excel 2013 spreadsheets

Usability and performance

  • Open Numbers ’08 spreadsheets
  • Easily access recently used fonts in the Fonts menu
  • Multitask while editing using new Slide Over, Split View and Picture in Picture on iPad*
  • Quickly access formatting tools from the new Shortcut Bar on iPad
  • Easily select text using new Multi-Touch gestures on iPad
  • Use keyboard shortcuts when connected to a wireless keyboard
  • Updated file format makes it easier to send spreadsheets via services such as Gmail and Dropbox
  • Use Handoff to seamlessly switch between iPad, Mac and iPhone
  • Edit spreadsheets in landscape orientation on iPhone and iPod touch
  • Search spreadsheets by name
  • Faster CSV import
  • Progress indicator for calculations
  • Column and row labels in tables
  • Inter-table alignment guides
  • Print floating comments
  • Usability improvements for resizing and positioning charts
  • Improved bidirectional language support

Accessibility

  • Add, remove and rearrange rows, columns and cells with VoiceOver
  • Get table header information with VoiceOver
  • Edit chart data and chart elements with VoiceOver
  • Interact with checkbox, slider, stepper, star rating and pop-up menu cells with VoiceOver
  • VoiceOver can now read relevant text-formatting details, including font name and font size, while editing
  • Add and review comments with VoiceOver
  • Access print preview with VoiceOver

Numbers for Mac

Editing

  • Instantly rearrange data in tables with new Transpose feature
  • Sort by multiple columns
  • Sort a subset of rows
  • Create custom data formats
  • Press the Option key to highlight rows and columns on mouseover
  • Drag and drop a CSV file onto a sheet
  • Automatically update an existing table by dragging in a CSV file

Charting

  • Add reference lines to charts
  • Chart date and duration values
  • Control the z-order of bubble chart labels
  • Custom number formats in charts are preserved on import of Numbers ’09 and Microsoft Excel spreadsheets

Design tools

  • Enhanced support for OpenType font features like small caps, contextual fractions, alternate glyphs and more
  • Force click images and get haptic feedback as you edit using Force Touch trackpad
  • View Collections, Moments, Favourites and Shared Albums from Photos in the Media Browser
  • Create table, chart and shape styles from an image
  • Improved cell border styling
  • Inter-table alignment guides
  • Customise the toolbar with your most important tools
  • Create custom table styles
  • Improved Instant Alpha image editing

Sharing

  • Shared Numbers spreadsheets can now be previewed on iOS and Android browsers
  • “View only” setting lets you share spreadsheets you want others to view but not edit
  • Share password-protected spreadsheets via iCloud link
  • Support for iCloud Drive

Printing

  • Set page margins
  • Create headers and footers
  • Page numbering options
  • Page ordering options
  • Change the zoom level during preview

Microsoft Excel compatibility

  • Improved Excel compatibility for charts, text overflows and nonrectangular masks
  • Export password-protected spreadsheets to XLSX format
  • Improved compatibility with Microsoft Excel 2013 spreadsheets
  • Headers and footers in Microsoft Excel spreadsheets are preserved on import

Usability and performance

  • Open Numbers ’08 spreadsheets
  • Easily access recently used fonts in the Fonts menu
  • Multitask while editing using new Split View
  • Use Handoff to seamlessly switch between iPad, Mac and iPhone
  • Updated file format makes it easier to send spreadsheets via services such as Gmail and Dropbox
  • Text auto-completes when editing cells
  • Improved text box behaviour
  • Window size and placement preserved on Save
  • Set default zoom in Preferences
  • AppleScript support
  • Progress indicator for calculations
  • Cell-based import feedback
  • Print floating comments
  • Usability improvements for resizing and positioning charts
  • Improved bidirectional language support

Accessibility

  • Edit chart data and chart elements with VoiceOver
  • Add and review comments with VoiceOver

Numbers for iCloud

Sharing

  • Preview shared spreadsheets on iOS and Android browsers
  • “View only” setting lets you share spreadsheets you want others to view but not edit
  • View a list of spreadsheets others have shared with you in the document manager
  • Share password-protected spreadsheets
  • Print your spreadsheets directly from the Tools menu

Collaboration

  • Collaborate with up to 100 people at the same time
  • View the list of collaborators currently in a spreadsheet
  • See cursors and selections for everyone in a spreadsheet
  • Jump to a collaborator’s cursor by clicking the name in the collaborator list
  • Jump to a collaborator’s sheet selection
  • Watch images and shapes animate as your collaborators move them around

Editing

  • Available worldwide in US English, French, German, Japanese, Simplified Chinese, Spanish, Brazilian Portuguese, Italian, Portuguese, Danish, Finnish, Swedish, Norwegian, Dutch, Polish, Traditional Chinese and Korean
  • Add comments
  • Filter tables
  • Restore previous versions of a spreadsheet
  • Edit pop-up menus
  • Objects on canvas automatically shift for table adjustments
  • Animate interactive charts
  • Add reference lines to charts
  • Support for curved lines in scatter and line charts
  • Create and format 2D and interactive charts
  • Flow text into adjacent cells
  • Keyboard shortcuts for precise rotating, resizing and repositioning of objects
  • Create links using the HYPERLINK function
  • Conditional highlighting rules are preserved on import
  • Custom data formats are preserved on import
  • Pop-up menus are preserved on import

Design tools

  • Create custom colours
  • Lock and unlock objects
  • Duplicate objects
  • Almost 200 new fonts
  • Apply rich formatting to text in table cells
  • Turn on Alternating Row Color in tables
  • Insert images up to 10MB in size

Microsoft Excel compatibility

  • Improved Excel compatibility for charts, text overflows and nonrectangular masks
  • Open password-protected Numbers ’09 and Microsoft Excel spreadsheets

Accessibility

  • Improved VoiceOver support for document manager

Usability and performance

  • Open Numbers ’08 spreadsheets
  • Use folders to organise your spreadsheets
  • Drag and drop to reorder sheets
  • Edit documents up to 1GB in size
  • Open spreadsheets directly from iCloud Mail
  • Export to CSV
  • Improved CSV import
  • Support for Retina display