Numbers for iCloud release notes

• Show subtotal summary labels in stacked bar, column, and area charts.

Get complete step-by-step instructions and information on all the features in Numbers for iCloud.

• Insert and play back videos in your spreadsheets.

• Create and edit pivot tables to quickly summarize, group, and rearrange data to explore patterns and trends.

• Sort, filter, and refresh pivot tables created on macOS, iPadOS, or iOS.
• Create a source data table for pivot table summary cells.

• 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).

• Link to web pages, email addresses, and phone numbers from objects such as shapes, lines, images, drawings, or text boxes.

• Enhance your spreadsheets with a variety of new, editable shapes.

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

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