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 or 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

Working with data

  • Instantly rearrange data in tables with new Transpose feature

Charting

  • 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

  • “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

  • Export password-protected spreadsheets to XLSX format
  • Improved compatibility with Microsoft Excel 2013 spreadsheets

Usability and performance

  • 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
  • Support for iOS 8
  • Column and row labels in tables
  • Inter-table alignment guides
  • Print floating comments
  • Usability improvements for resizing and positioning charts
  • Improved accessibility
  • Improved bidirectional language support

Numbers for Mac

Working with data

  • 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 right onto a sheet
  • Automatically update an existing table by dragging in a CSV file

Charting

  • 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

  • Improved cell border styling
  • Inter-table alignment guides
  • Customize the toolbar with your most important tools
  • Create custom table styles
  • Improved Instant Alpha image editing
  • Media Browser improvements, including search

Sharing

  • “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

  • 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

  • All-new design inspired by OS X Yosemite
  • 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 autocompletes 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