Numbers for iCloud release notes

New shapes

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

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

• New functions, including XLOOKUP, XMATCH, and REGEX, let you match patterns, manipulate text, and create flexible formulas. Learn more
• Easily add captions and titles to images, videos, shapes, and other objects. Learn more
• Format text as superscript or subscript, adjust capitalization, change text background color, and more. Learn more

• Add a Numbers spreadsheet to a shared iCloud Drive folder to automatically start collaborating. Learn more
• Use new keyboard shortcuts to quickly select rows and columns.
• Apply a color to the background of a sheet. Learn more
• Open spreadsheets containing more rows and columns than ever before. Learn more
• Easily access templates in a redesigned template chooser.
• Add a drop cap to text in a shape. Learn more
• 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

• Create links from text to other sheets in a spreadsheet. Learn more
• Add rows to filtered tables.
• Place images, shapes, and equations inline in text boxes so they move with text. Learn more

• Make precise changes to table row and column sizes in the Format pane.
• Improvements to Smart Categories usability and performance.
• View and recover recently deleted spreadsheets in the Document Manager.

• Use smart categories to quickly organize and summarize tables to gain new insights. Learn more
• Quickly add links to web pages and email addresses.
• Enhance your spreadsheets with a variety of new editable shapes.

• Adjust shadows, backgrounds, and gaps in charts.
• Give charts a new look with rounded corners on columns and bars.
• Enhance your spreadsheets with a variety of new editable shapes.

• Add an interactive image gallery to your spreadsheets to view a collection of photos. 
• Use donut charts to visualize your data in an engaging new way.
• Enhance your spreadsheets with a variety of new editable shapes.
• Improved bidirectional support for Arabic and Hebrew.

• Redesigned document manager: open spreadsheets stored anywhere in iCloud Drive, easily find shared spreadsheets, and create nested folders.

• Enhance your documents using a library of over 500 professionally drawn shapes. Learn more
• Reply to comments and join threaded conversations. Learn more
• Support for advanced image fill-in graphics.
• Insert and edit object connection lines.
• The Stock and Currency functions now return data from the previous market day’s close. Learn more

• A simplified design gives you easy access to the tools you need. 
• New stock and currency functions provide up-to-date securities data in tables.
• Add gradient and image fills to graphics.
• New align and distribute options make it easier to position objects in your spreadsheet.
• Preview older versions of your spreadsheet before choosing which one to restore. 
• Set dates, times, and currencies for your language or region when you create a document.

• Support for real-time collaboration with Numbers on Mac, iPad, and iPhone (feature in beta).
• Collaborate with specific people (feature in beta).

See the release notes for Pages and Keynote for iCloud.