What's new in Pages, Numbers, and Keynote.

We’re constantly updating Pages, Numbers, and Keynote. So your favorite 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

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
  • Support for iOS 8
  • iCloud Drive compatibility

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

  • Customize 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 autocompletes when editing cells
  • Improved text box behavior
  • Window size and placement preserved on Save
  • Set default zoom in Preferences
  • AppleScript support
  • Progress indicator for calculations
  • Cell-based import feedback

Numbers for iCloud

Sharing

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

Working with data

  • 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 color 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 organize 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