Numbers

How to insert tables into emails in Mail on Mac

Table in the Mail app on Mac

Even though the Mail app on your Mac has some terrific features for composing emails like adding drawings or inserting and annotating images, it currently lacks the ability to include a table. For formatting an email in a matrix structure, you can still insert a table into a new message. The trick is, you’ll copy that table from another app on your Mac.

While there are probably plenty of apps you can use to do this, the easiest way is with one that’s built right into your Mac. Here’s how to insert tables into emails in the Mail app on Mac.

How to password-protect and export PDFs from Pages, Numbers and Keynote

Set password Pages iPhone

When you’re working with documents, you may need to convert one to a PDF to share it or send it. Whether it’s a report, spreadsheet, or slideshow, the Apple iWork apps let you save it as a PDF.

In addition, you can add password protection. This is ideal for documents that need more security.

For these types of situations, we want to help you not only save your documents in the format you need but keep them safe too. Here’s how to password-protect and export PDFs from Pages, Numbers, and Keynote.

How to record audio in Pages, Numbers and Keynote on iOS and Mac

Record Audio Keynote Mac

When you create a document, spreadsheet, or presentation, the addition of audio can be the perfect way to get your point across. And in Pages, Numbers, and Keynote recording and inserting audio is easy to do.

If you’re just trying this for the first time, we’re here to help. This tutorial shows you how to record audio in Pages, Numbers, and Keynote, on both iOS and Mac.

How to add links in Pages and Numbers on Mac

Add links in Numbers app on Mac

In Pages, you can link to other pages in Page Layout documents, and in Numbers, you can create links to other sheets in your spreadsheet. There are other types of links you can add in Pages and Numbers on Mac that are just as handy, and this tutorial walks you through all of them.

How to fill down with Numbers Autofill on Mac

Autofill in the Numbers app on MacBook

If you use Apple Numbers for your spreadsheet application, then you might already be familiar with the Autofill feature. This handy tool lets you quickly fill other cells with data from adjacent ones. You can fill things like patterns, words, and numbers up, down, left, or right. But when it comes to filling down, and you have hundreds or thousands of rows, it can get tricky.

This tutorial shows you two ways that you can fill down with the Numbers Autofill feature on Mac for small spreadsheets as well as large ones.

How to add, delete, hide and move columns and rows in Numbers on Mac

work with columns and rows in Numbers on Mac

The columns and rows in Numbers are what keep your data organized, nice and neat. But there may come a time when a column or row isn’t working out as well as you’d like. Maybe you no longer need a data set in a row, or perhaps you want a column moved from the right side to the left. Maybe you just need to add several columns or rows to prepare for incoming data or want to hide specific data sets.

To help you work with your spreadsheets, here’s how to add, delete, hide, and move columns and rows in Numbers on Mac.

How to use common functions and formulas in Numbers on Mac and iOS

Functions and formulas in the Numbers app

One of the best features of spreadsheet applications like Numbers is its built-in functions and formulas. These handy little tools let you work with numbers much more easily. You can sum a column, get the maximum number in a row, average a group of cells, and more without doing the calculations yourself.

While there are many built-in formulas, a handful of them are used most often. So, Apple makes these easily accessible in the Numbers application. They include sum, average, minimum, maximum, count, and product. This tutorial shows you how to work with these common functions and formulas in Numbers on both Mac and iOS.

How to set a password to protect documents in Pages, Numbers, and Keynote apps on iPhone, iPad, and Mac

Password protect Pages, Numbers, and Keynote documents

Whether you use Apple’s Pages, Numbers, and Keynote applications for work or personal reasons, you might want to protect a document with a password. This can keep prying eyes from being able to access private files.

Once you set a password, no matter where you try to open that document, you’ll need the password. For instance, if you set a password for a Pages document on Mac, you’ll still need the password to open it on your iPad. This adds a nice layer of security to your most important files.

Here’s how to password-protect your Pages, Numbers, and Keynote documents on iPhone, iPad, and Mac.

How to convert a Numbers file to Excel on Mac, iPhone, and iPad

Convert Numbers to Excel

While you may work and create your spreadsheets in Numbers, there may be a time when you need one of those documents in the Microsoft Excel file format.

You can easily export spreadsheets into different formats for viewing and editing with other applications. Here’s how to convert a Numbers file to Excel on Mac, iPhone, and iPad.