Numbers

How to sort your data in Apple Numbers on Mac

Sort data in Numbers on Mac

If you use Apple Numbers as your spreadsheet application, there may come a time when you need to sort your data. You might want to sort by dollar amount, date, or alphabetically to quickly find the data you need.

The Numbers app gives you a couple of ways to easily sort the data in your sheets. There are quick options in the column shortcut menu along with rules you can set up for more fine-tuned sorting. Here, we’ll show you both.

How to manage sheets in Apple Numbers on Mac

Manage sheets in the Numbers app on Mac

One of the greatest features of a spreadsheet application like Numbers is that you can use multiple sheets in one workbook. This eliminates the need for a new document each time you want a separate sheet, especially for those related spreadsheets.

You can use workbooks containing multiple sheets based on years, departments, bills, products, or something similar. And with a workbook that holds several worksheets comes the management of those sheets. It’s not difficult, but if you’re new to this app or spreadsheet applications in general, here are some tips for using sheets in Numbers.

How to filter your data in Apple Numbers on Mac

Filter your data in Numbers on Mac

Most times, there’s more to the data you add in Numbers than just entering it. You may also want to analyze it. Whether it’s company sales, personal financials, or customer records, you can use filters to display only the data you want to see.

Numbers has features that let you apply a quick filter or set up filtering rules. Both of which are handy depending on the amount of data you have and the data you need. This tutorial shows you how to filter your data in Apple Numbers.

Forgot your document password in Pages, Numbers, or Keynote? Try this

Set Password Remember Keychain Numbers Mac

Protecting your document with a password can keep sensitive data safe. And we’ve shown you how to password-protect documents in Pages, Numbers, and Keynote, as well as how to change or remove that password. But what happens if you forget the password?

We’ll show you one way to recover that password on Mac, as well as tips for preventing this in the future.

How to format and customize lists in Pages, Numbers and Keynote

Format Customize Lists Pages Mac

If you use Pages, Numbers, or Keynote to create documents, spreadsheets, and slideshows, you may want to add a list. You might want to use an ordered list with letters or numbers. Or, you may want a bulleted list that uses dots or dashes.

Lucky for you, you can format lists in these three apps pretty much anyway you want. And you can customize more options than you might realize.

For your next list, here’s how to format and customize it in Pages, Numbers, and Keynote on Mac and iOS.