Everything
adds up.

With its impressive tables and images, Numbers makes it possible to create beautiful spreadsheets, and comes included with most Apple devices. Use Apple Pencil on your iPad to add useful diagrams and colorful illustrations. And with real-time collaboration, your team can work together, whether they’re on Mac, iPad, iPhone, or a PC.

Numbers brings your data to life.

Numbers starts you off with a blank canvas instead of an endless grid, so you have the freedom to move everything around your canvas at will and organize your data any way you choose. And everyone editing the spreadsheet has access to the same powerful features on iOS, iPadOS, and macOS.

It’s easy getting started.

Drop your data into one of the gorgeous, ready-to-use templates, then customize your data any way you like. Select fonts and style cell borders. And add, resize, and apply styles to tables.

Have Numbers do the math.

Numbers supports hundreds of functions. Its intuitive tools make it simple to perform complex calculations with great precision, figure out formulas, filter the data, and sum up what it all means. Use pivot tables and Smart Categories to quickly organize and summarize tables for an even deeper understanding of the story behind your data.

Explore patterns and trends with pivot tables, now in Numbers

Easily create a pivot table to view your data in different ways

Quickly summarize, group, and rearrange data while your source data remains unchanged

Stunning results. Instantly.

Bar and column charts with clearly labeled numbers and adjustable sizes, insightful radar and donut charts, interactive graphs, and a library of over 700 customizable shapes help you turn your numbers into beautiful data visualizations.

What’s new in Numbers.

Get the updates. Then get in touch.

Stay up to date when people join, edit, or comment in collaborative spreadsheets and easily get in touch with your team using Messages and FaceTime.

Get more done on iPad.

Quickly insert objects, find settings, and get to your favorite tools with the customizable toolbar. And Stage Manager makes it easy to multitask across multiple spreadsheets and apps at the same time. *

Work smarter with new functions.

Compare values and combine text with even more functions, including SWITCH, BITAND, CONCAT, TEXTJOIN, and more.

Find trends with pivot tables.

This powerful and intuitive data analysis tool makes exploring patterns and trends easy and beautiful. You can even open Microsoft Excel files with pivot tables right in Numbers. And they aren’t just for Mac — pivot tables work great on your iPad and iPhone, too.

Highlight comparisons with radar charts.

Visually compare multiple variables across different series. Radar charts make it easy to see similarities and differences clearly.

Forms. Reimagined.

With redesigned forms, it’s never been easier to create and customize a form. Add a form to any table or use the Basic form template.

XLOOKUP comes to Numbers.

With XLOOKUP, you can find values in columns and rows or look for exact, approximate, or partial matches. This function makes Numbers even more compatible with Microsoft Excel.

Powerful RegEx features.

Match text flawlessly with RegEx functions. Easily manipulate text, match patterns in your data, and create formulas that are even more flexible.

Any spreadsheet.
Any device. Anytime.

You don’t work in one place on just one device. The same goes for Numbers. Work seamlessly across all your Apple devices. The spreadsheets you create using a Mac or iPad will look the same on an iPhone or web browser — and vice versa.

You can also work on spreadsheets stored on iCloud or Box using a PC.

Bring everyone

Work together in the same spreadsheet, from across town or across the world. You can see your team’s edits as they make them — and they can watch as you make yours, too. You can even get notifications when people join, edit, or comment. Just click or tap the Share button and invite people to join.

Use Apple Pencil when

Sketch diagrams, mark up, or add color to help you visualize your data with Apple Pencil on your iPad.

Plays well with Office.

Teaming up with someone who uses Microsoft Excel? Numbers makes it a great working relationship. You can save Numbers spreadsheets as Excel files. Or import and edit Excel spreadsheets right in Numbers.

Resources

See everything that’s new in Numbers

• What’s new in Numbers for iPhone and iPad
• What’s new in Numbers for Mac
• Numbers for iCloud release notes

Additional Resources

• Get Numbers support
• Learn about Microsoft Office compatibility
• Learn about collaboration for Pages, Numbers, and Keynote
• Get formulas and functions help

Numbers User Guides

• Numbers User Guide for Mac
• Numbers User Guide for iPad
• Numbers User Guide for iPhone
• Numbers User Guide for Web

Keynote

Design stunning, memorable
presentations.

Pages

Create documents that are,
in a word, beautiful.

Apple Footer

• * Requires iPadOS 16. Stage Manager is available on iPad Air (5th generation), iPad Pro 12.9-inch (3rd generation and later), and iPad Pro 11-inch (1st generation and later). External display support is available on iPad Air (5th generation), iPad Pro 12.9-inch (5th generation and later), iPad Pro 11-inch (3rd generation and later).

• Pages for iOS, Numbers for iOS, and Keynote for iOS are available on the App Store. iOS 15 or later required. Downloading apps requires an Apple ID.
• Pages for iPadOS, Numbers for iPadOS, and Keynote for iPadOS are available on the App Store. iPadOS 15 or later required. Downloading apps requires an Apple ID.
• Pages for Mac, Numbers for Mac, and Keynote for Mac are available on the Mac App Store. macOS 12 or later required. Downloading apps requires an Apple ID.
• Keynote for Apple Watch is available on the App Store. watchOS 2.0 or later required. Downloading apps requires an Apple ID.
• Some features may require internet access; additional fees and terms may apply.
• Features are subject to change. iWork for iCloud is currently available worldwide in Arabic, Brazilian Portuguese, Chinese (Simplified), Chinese (Traditional), Danish, Dutch, Finnish, French, German, Hebrew, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Spanish, Swedish, and U.S. English and requires an iCloud account and an internet connection. iWork for iCloud works with a Mac or PC using Safari 11.1.2 or later, Google Chrome, or Microsoft Edge.
• Scribble support is currently available worldwide in Arabic (Saudi Arabia), Cantonese (China mainland, Hong Kong), English (Australia, Canada, India, Singapore, UK, U.S.), French (France), German (Germany), Italian (Italy), Japanese (Japan), Korean (South Korea), Mandarin Chinese (China mainland, Taiwan), Russian (Russia), Spanish (Mexico, Spain, U.S.), Thai (Thailand), Turkish (Türkiye). Downloading apps requires an Apple ID.

Руководство пользователя Numbers

Работа с любой таблицей всегда начинается с выбора модели, называемой шаблоном. В шаблонах можно замещать диаграммы и данные по умолчанию своим собственным контентом, а также добавлять новые таблицы, формулы и другие объекты.

Добавление данных в таблицу

Можно ввести собственные данные или импортировать данные из другого файла. Также можно добавлять в любую ячейку различные встроенные формулы, например сумму или среднее значение. Чтобы упорядочивать данные и выявлять тренды, можно добавлять фильтры, группировать данные по категориям, создавать сводные таблицы и многое другое.

Создание диаграммы

Можно иллюстрировать данные двухмерными или трехмерными диаграммами, а также интерактивными диаграммами. При изменении данных в таблице диаграмма будет обновляться автоматически.

Структурирование данных с помощью листов

Можно структурировать данные в таблице с помощью разных листов. Каждый лист будет соответствовать определенному типу информации, которую Вы хотите упорядочить, например доходы, расходы и т. д. Чтобы перейти к нужному листу, коснитесь соответствующей вкладки вверху таблицы.

Совместная работа в режиме реального времени

Приглашайте других пользователей работать над таблицей вместе с Вами. Все приглашенные пользователи видят вносимые изменения, при этом Вы можете выбирать, кому разрешить редактирование таблицы, а кому — только просмотр.

Это руководство поможет Вам начать работу с Numbers 13.1 на iPhone. Чтобы узнать, какая версия Numbers у Вас установлена, перейдите в «Настройки» > «Numbers». Чтобы ознакомиться с Руководством пользователя Numbers, коснитесь «Оглавление» вверху страницы либо введите слово или фразу в поле поиска. Также можно загрузить руководство из Apple Books (в регионах, где этот сервис доступен).

За более подробной информацией обращайтесь на сайт поддержки Numbers.

При подготовке материала использовались источники:
https://www.apple.com/numbers/
https://support.apple.com/ru-ru/guide/numbers-iphone/welcome/ios