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. To help you keep up with the latest improvements, we’ve listed them all right here.

Numbers for iOS

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

Sharing

  • New “view only” setting lets you share spreadsheets you want others to view but not edit
  • Share password-protected spreadsheets via iCloud link

Microsoft Excel compatibility

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

Usability and performance

  • Edit spreadsheets in landscape orientation on iPhone and iPod touch
  • Search spreadsheets by name
  • Faster CSV import
  • Progress indicator for calculations

Numbers for Mac

Working with data

  • 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

  • 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

  • Customise the toolbar with your most important tools
  • Create custom table styles
  • Improved Instant Alpha image editing
  • Media Browser improvements, including search

Sharing

  • New “view only” setting lets you share spreadsheets you want others to view but not edit
  • Share password-protected spreadsheets via iCloud link

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

  • 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