What’s new in Numbers for iCloud
Spreadsheet manager.(September 2023) Find spreadsheets more easily in the redesigned spreadsheet manager. In Recents view, spreadsheets are now grouped by time periods, and in either Recents or Browse view, you can choose to view your spreadsheets in a list as well as by icon. You can also now use the More button to get information about the spreadsheet size, and quickly zoom in on the first sheet.
Stacked chart summary labels.(June 2023) Show subtotals for the data in stacked bar, column, and area charts, making it even easier to understand data trends. See Edit chart text, markings, and labels.
Version history
We’re frequently updating Numbers for iCloud. Updates are cumulative, so when you open Numbers on iCloud.com, it has all the latest features. You can see all the features included with each release below.
September 2023
Easily view and manage your files with the redesigned spreadsheet browser.
Remove external borders on charts imported from Microsoft Office files.
June 2023
Show subtotal summary labels in stacked bar, column, and area charts.
October 2022
Insert and play back videos in your spreadsheet.
June 2022
Create and edit pivot tables to quickly summarize, group, and rearrange data to explore patterns and trends.
April 2022
Sort, filter, and refresh pivot tables created on macOS, iPadOS, or iOS.
Create a source data table for pivot table summary cells.
September 2021
View, style, and add charts for pivot tables created on Mac, iPad, or iPhone.
Use radar charts to visualize and compare multiple variables to show similarities and differences in your data.
Find duplicate entries and unique values in your data with improved filters, and use redesigned Quick Filters to easily show or hide rows that match a specific value.
Flexible collaboration allows participants to add others to a shared spreadsheet (requires iOS 15, iPadOS 15, or macOS Monterey).
June 2021
Link to webpages, email addresses, and phone numbers from objects such as shapes, lines, images, drawings, or text boxes.
September 2020
Enhance your spreadsheets with a variety of new, editable shapes.
July 2020
New functions, including XLOOKUP, XMATCH, and REGEX, let you match patterns, manipulate text, and create flexible formulas.
Easily add captions and titles to images, videos, shapes, and other objects.
Format text as superscript or subscript, adjust capitalization, change text background color, and more.
March 2020
Add a Numbers spreadsheet to a shared iCloud Drive folder to automatically start collaborating.
Use new keyboard shortcuts to quickly select rows and columns.
Apply a color to the background of a sheet.
Open spreadsheets containing more rows and columns than ever before.
Easily access templates in a redesigned template chooser.
Add a drop cap to text in a shape.
Use new text layout options to add borders, paragraph backgrounds, and columns.
Enhance your spreadsheets with a variety of new, editable shapes.
Use Unite, Intersect, Subtract, and Exclude commands to create new shapes.