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

  • 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

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

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

Numbers for iCloud

Sharing

  • “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 and Brazilian Portuguese
  • 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

  • Almost 200 new fonts
  • More colour options in the format panel
  • 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

  • Open password-protected Numbers ’09 and Microsoft Excel spreadsheets

Accessibility

  • Improved VoiceOver support for document manager

Usability and performance

  • All-new design
  • Use folders to organise your spreadsheets
  • Drag and drop to reorder sheets
  • Open spreadsheets directly from iCloud Mail
  • Edit spreadsheets up to 1GB in size
  • Export to CSV
  • Improved CSV import
  • Support for Retina display