What's new in Numbers 14.0
Apr 6, 2024
- Streamlined in-app notifications inform you when a person joins a collaborative spreadsheet for the first time
- Preserve file format and full quality when adding HEIC photos taken on iPhone or iPad
- Press and hold the Command key to select noncontiguous words, sentences, or paragraphs
- Additional stability and performance improvements
New in Numbers 13.2 (Sep 22, 2023)
- Bring new dimension to your spreadsheets with 3D objects in USDZ format
- Remove external borders on charts imported from Microsoft Office files
New in Numbers 13.1 (Jun 14, 2023)
- Show subtotal summary labels in stacked bar, column, and area charts
- Add scalable vector graphics (SVGs) to your spreadsheets and preserve visual quality at any size
- Break apart imported SVG images and save them to your shapes library for future use
New in Numbers 13.0 (Mar 30, 2023)
- Export and send a copy of your spreadsheet in a different format right from the Share menu
- Improved performance for large spreadsheets on Mac computers with Apple silicon
- Includes improvements and bug fixes for collaboration activity
New in Numbers 12.2.1 (Nov 30, 2022)
- This update contains bug fixes and improvements.
New in Numbers 12.2 (Oct 26, 2022)
- An all-new activity view shows recent changes in collaborative spreadsheets, including when people join, comment, and make edits
- Get notifications when others join or make changes in your shared spreadsheets
- Share a spreadsheet in Messages to instantly start collaborating with your team and see updates right in the Messages conversation (Requires macOS 13)
- Send a message or start a FaceTime call right from a collaborative spreadsheet (Requires macOS 13)
- Now use the File menu to manage your shared spreadsheet or send a copy
- Compare values and combine text with new functions, including BITAND, BITOR, BITXOR, BITLSHIFT, BITRSHIFT, ISOWEEKNUM, CONCAT, TEXTJOIN, and SWITCH.
- A new option lets you automatically remove an image’s background to isolate its subject (Requires macOS 13)
New in Numbers 12.1 (Jun 21, 2022)
- Improved performance when inserting rows and columns in large tables
New in Numbers 12.0 (Apr 8, 2022)
- Copy a snapshot of table cells without formulas, categories, or hidden values
- Use Shortcuts on macOS Monterey to create or open spreadsheets and add rows to a table
- Create formulas and quickly fill cells with autofill using VoiceOver
New in Numbers 11.2 (Sep 29, 2021)
- Pivot tables provide a powerful and flexible way to view and analyze data
- Create beautifully formatted pivot tables in just a few clicks
- Quickly summarize, group, and rearrange data to explore patterns and trends
- Instantly show data by sum, average, count, or display percentage and running total values
- Add pivot charts to see your data in different ways
- Import and export Excel spreadsheets with pivot tables
- Radar charts help you visually compare multiple variables at once to easily show similarities and differences in your data
- Enhanced quick filters help you easily select values to show or hide, and improved filters find duplicate entries and unique values in your data
- Flexible collaboration allows participants to add others to a shared spreadsheet*
- Instant translation lets you translate selected text in up to 11 languages and add the translation to your spreadsheet with a click*
- Create new spreadsheets from the app icon in the Dock
- *Requires macOS Monterey
New in Numbers 11.1 (Jun 1, 2021)
- Link to web pages, email addresses, and phone numbers from objects such as shapes, lines, images, drawings, or text boxes
New in Numbers 11.0 (Mar 24, 2021)
- Updated media browser offers enhanced search options and new content categories such as Recents, Portraits and Live Photos
- Ability to add phone number links to table cells, text objects, and shapes
- AppleScript functionality to change a spreadsheet password or open password-protected spreadsheets
New in Numbers 10.3.9 (Jan 15, 2021)
- This update contains stability and performance improvements.
New in Numbers 10.3.5 (Nov 13, 2020)
- Refined new design on macOS Big Sur
- Stability and performance improvements
New in Numbers 10.2 (Sep 23, 2020)
- Improved performance when working with large tables.
- Enhance your spreadsheets with a variety of new, editable shapes.
New in Numbers 10.1 (Jul 10, 2020)
- Play YouTube and Vimeo videos right in your spreadsheets.*
- Easily add captions and titles to images, videos, shapes, and other objects.
- New functions, including XLOOKUP, XMATCH, and REGEX, let you match patterns, manipulate text, and create flexible formulas.
- *May not be available in all regions.
New in Numbers 10.0 (Apr 1, 2020)
- Create spreadsheets with more rows and columns than ever before.
- Apply a color to the background of a sheet.
- Add a Numbers spreadsheet to a shared iCloud Drive folder to automatically start collaborating. Requires macOS 10.15.4.
- Edit shared spreadsheets while offline and your changes will upload when you’re back online.
- Easily access your recently used templates in a redesigned template chooser.
- Print or export a PDF of your spreadsheet with comments included.
- Add a drop cap to text in a shape.
- Enhance your spreadsheets with a variety of new, editable shapes.
New in Numbers 6.2.1 (Nov 15, 2019)
- This update contains stability and performance improvements.
New in Numbers 6.2 (Oct 1, 2019)
- Improved performance when working with large tables.
- Easily add HEVC-formatted movies to spreadsheets, enabling reduced file size while preserving visual quality.
- Add accessibility descriptions to audio, video, and drawings.
- Improved accessibility of exported PDFs.
New in Numbers 6.1 (Jun 26, 2019)
- Greatly improved accuracy using the enhanced 128-bit calculation engine.
- Style your text by filling it with gradients or images, or by applying new outline styles.
- Create links from text to other sheets in a spreadsheet.
- Place images, shapes, and equations inline in text boxes so they move with text.
- Using face detection, subjects in photos are intelligently positioned in placeholders and objects.
- Improved performance while editing and sorting tables.
- Add rows to filtered tables.
New in Numbers 6.0 (Mar 29, 2019)
- Performance and usability improvements to Smart Categories.
- Save custom shapes and templates that automatically sync to all your devices using iCloud.
- Improved performance while collaborating on spreadsheets.
- Edit grouped objects while collaborating.
- Enhancements to Excel and comma separated value file import.
- Support for vertical text in shapes and text boxes in Chinese, Japanese, and Korean languages.
New in Numbers 5.3 (Nov 8, 2018)
- This update contains stability and performance improvements.
New in Numbers 5.2 (Sep 18, 2018)
- Use Smart Categories to quickly organize and summarize tables to gain new insights.
- Group your data based on unique values and date ranges, including day of week, day, week, month, quarter, and year.
- Instantly show count, subtotal, average, maximum, and minimum values for columns in each group.
- Create charts of your summarized data.
- Easily reorder categories to see your data in a different way.
- Support for Dark Mode gives Numbers a dramatic dark look. Toolbars and menus recede into the background so you can focus on your content. Requires macOS Mojave.
- Support for Continuity Camera allows you to take a photo or scan a document with your iPhone and have it automatically appear in your spreadsheet on your Mac. Requires macOS Mojave and iOS 12.
- Easily record, edit, and play audio right in a spreadsheet.
- Enhance your spreadsheets with a variety of new editable shapes.
- Performance and stability improvements.
New in Numbers 5.1 (Jun 15, 2018)
- Give charts a new look with rounded corners on columns and bars.
- Add mathematical equations using LaTeX or MathML notation.
- Enhance your documents with a variety of new editable shapes.
- Improved compatibility with Microsoft Excel.
New in Numbers 5.0.1 (May 4, 2018)
- This update contains stability and performance improvements.
New in Numbers 5.0 (Mar 28, 2018)
- Collaborate in real time on spreadsheets stored in Box. Requires macOS High Sierra.
- Use donut charts to visualize data in an engaging new way.
- Add an interactive image gallery to view a collection of photos.
- Enhance spreadsheets with a variety of new editable shapes.
- Improved, customizable import of CSV and text data, with support for custom delimiters and fixed-width files.
- Additional options for reducing the file size of spreadsheets.
- Full bidirectional support for Arabic and Hebrew.
New in Numbers 4.3.1 (Nov 10, 2017)
- This update contains stability and performance improvements.
New in Numbers 4.3 (Sep 20, 2017)
- Performance and stability improvements.
New in Numbers 4.2 (Jun 14, 2017)
- Enhance your spreadsheets using a library of over 500 professionally drawn shapes
- Reply to comments and join threaded conversations
- Support for print preview in collaborative spreadsheets
- New auto-correction and text replacement options save time while typing
- The Insert Stock Quote feature and the Stock and Currency functions now return data from the previous market day’s close.
New in Numbers 4.1.1 (Apr 26, 2017)
- This update contains stability and performance improvements.
New in Numbers 4.1 (Mar 27, 2017)
- Easily add current or historical stock information to spreadsheets
- Use the new My Stocks template to easily track your portfolio
- Quickly open password-protected spreadsheets using Touch ID on the new MacBook Pro with Touch Bar
- New leader lines make pie charts easier to read
- Easily replace fonts throughout an entire spreadsheet
- While collaborating on a spreadsheet, you can now cut, copy, paste, and duplicate sheets
- Customize dates, times, and currencies for your language or region
New in Numbers 4.0.5 (Oct 27, 2016)
- Support for Touch Bar on the new MacBook Pro lets you easily edit text, shapes, tables and charts
- Stability and performance improvements
New in Numbers 4.0 (Sep 20, 2016)
- Use tabs to work with multiple spreadsheets in one window
- Wide color gamut image support
- Real-time collaboration (feature in beta):
- Edit a spreadsheet with others at the same time in Numbers on Mac, iPad, iPhone, and iCloud.com
- Share your spreadsheet publicly or with specific people
- See who else is in a spreadsheet
- See participants’ cursors as they’re editing
New in Numbers 3.6.2 (May 10, 2016)
- This update contains stability improvements and bug fixes.
New in Numbers 3.6.1 (Nov 11, 2015)
- Resolves an issue where some Microsoft Excel spreadsheets would not open
- Additional bug fixes
- Stability and performance improvements
New in Numbers 3.6 (Oct 15, 2015)
- Multitask while editing using new Split View in El Capitan
- Open Numbers ’08 spreadsheets
- Shared Numbers spreadsheets can now be previewed on iOS and Android browsers
- Force click images and get haptic feedback as you edit using Force Touch trackpad
- Easily access recently used fonts in the Fonts menu
- Enhanced support for OpenType font features like small caps, contextual fractions, alternative glyphs and more
- View Collections, Moments, Favorites and Shared Albums from Photos in the Media Browser
- Add reference lines to charts
- Create table, chart and shape styles from an image
- Edit chart data and chart elements with VoiceOver
- Add and review comments with VoiceOver
- Additional AppleScript options for PDF export
- Additional AppleScript options for Excel export
- Improved Excel compatibility for charts, text overflows and non-rectangular masks
- Improved Excel export
New in Numbers 3.5.3 (Apr 22, 2015)
- This update contains stability improvements and bug fixes.
New in Numbers 3.5.2 (Jan 9, 2015)
- This update contains stability improvements and bug fixes.
New in Numbers 3.5 (Oct 17, 2014)
- All-new design inspired by OS X Yosemite
- Instantly switch between iPad, Mac and iPhone with Handoff
- Support for iCloud Drive
- Updated file format makes it easier to send spreadsheets via services like Gmail and Dropbox
- Instantly rearrange data in tables with new transpose feature
- Inter-table alignment guides
- Improved cell border styling
- Print floating comments
- Usability improvements for resizing and positioning charts
- Improved bi-directional language support
New in Numbers 3.2.2 (Aug 22, 2014)
- This update contains stability improvements and bug fixes.
New in Numbers 3.2 (Apr 2, 2014)
- New "view only" setting lets you share spreadsheets you want others to view but not edit
- Set margins in print setup
- Create headers and footers in print setup
- New printing options: page numbering, page ordering and zoom
- Create custom data formats
- Create custom table styles
- Drag and drop a CSV file directly into a sheet
- Automatically update an existing table by dragging in a CSV file
- Control the z-order of bubble chart labels
- Cell-based import feedback
- Improved text box behaviour
- Media Browser improvements, including search
- Improved Instant Alpha image editing
- Improved Microsoft Excel compatibility
- Improved AppleScript support
- Usability improvements
New in Numbers 3.1 (Jan 24, 2014)
- Sort by multiple columns
- Sort a subset of rows
- Text autocompletes when editing cells
- Chart date and duration values
- Optionally highlight rows and columns on mouseover
- Progress indicator for calculations
- Custom number formats in charts are preserved on import of Numbers ’09 and Microsoft Excel spreadsheets
- Share password-protected spreadsheets via iCloud link
- Export password-protected spreadsheets to XLSX format
- Improvements to AppleScript support
- Improved compatibility with Microsoft Excel 2013 spreadsheets
- Bug fixes and stability improvements
New in Numbers 3.0.1 (Nov 22, 2013)
- Customize the toolbar with your most important tools
- Window size and placement preserved on Save
- Set default zoom in Preferences
- Stability improvements and bug fixes
New in Numbers 3.0 (Oct 23, 2013)
- Stunning new user interface
- Brand-new Apple-designed templates
- Simplified toolbar gives you quick access to shapes, media, tables, charts, and sharing options
- New Format Panel automatically updates based on selection
- Quickly click through a spreadsheet using new tab navigation
- Get function suggestions as soon as you start typing a formula
- Get live formula results, error checking, exact value, and cell format with the new smart cell view
- Add your favorite functions to Quick Calculations for instant results
- Search the integrated function browser for built-in help and sample formulas
- Use gorgeous preset styles to make your text, tables, shapes, and images look beautiful
- Animate data with new interactive column, bar, scatter, and bubble charts
- Use new 2D bubble charts
- Enhanced conditional highlighting makes it easy to automatically highlight cells based on numbers, text, dates, and durations
- Easily filter through large tables with the new Filter Panel
- New star ratings cell format
- Quickly and easily share a link to your work via Mail, Messages, Twitter, or Facebook
- Anyone with the link will always have access to the latest version of the spreadsheet and can edit it with you at iCloud.com with Numbers for iCloud beta
- All-new calculation engine for fast performance
- New unified file format across Mac, iOS, and web makes spreadsheets work seamlessly everywhere
- Turn on Coaching Tips for guided in-app help
New in Numbers 2.3 (Dec 5, 2012)
- Adds support for Numbers for iOS 1.7.
New in Numbers 2.2 (Jul 25, 2012)
- This update adds support for OS X Mountain Lion and takes advantage of the following features:
- iCloud: Store spreadsheets in iCloud and keep them automatically up to date across your Mac, iPad*, iPhone*, iPod touch*, and the web. Changes made to a spreadsheet on one device automatically appear on all your other devices.
- Dictation: Speak words, numbers, or sentences and watch them appear in your spreadsheet.
- Numbers 2.2 is also enhanced to take advantage of the Retina display on the new MacBook Pro so spreadsheets appear sharper and more vibrant.
- * Requires Numbers 1.6.1 or later installed on iOS device.
New in Numbers 2.1 (Jul 21, 2011)
- Adds support for Mac OS X Lion and takes advantage of the following features:
- Full Screen
- Resume
- Auto Save
- Versions
New in Numbers 2.0.5 (Jan 13, 2011)
- Adds public sharing and private upload options for iWork.com public beta.
New in Numbers 2.0.4 (Aug 27, 2010)
- Fixes an issue with tables.
New in Numbers 1.0.3 (Feb 2, 2009)
- This update addresses general compatibility issues.
New in Numbers 1.0.1 (Sep 28, 2007)
- This update primarily addresses issues with tables and performance.