Looking to make your document or spreadsheet richer with video content? This tutorial shows you how to add and play a YouTube or Vimeo video in the Pages and Numbers app on iPhone, iPad, and Mac.
Numbers
How to work with basic Categories in Numbers on Mac
Want to view your spreadsheet data in different ways? In this tutorial, we will show you how to use basic categories in the Numbers app on your Mac.
How to sort your data in Apple 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
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
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
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
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.
How to set a default template in Pages, Numbers and Keynote on Mac
This tutorial shows you how to set a default template in Pages & Numbers and a default theme in Keynote so you can save yourself an extra step while creating new documents, spreadsheets, and presentations.
How to customize and create paragraph or text styles in Pages, Numbers, and Keynote
This tutorial shows you how to edit paragraph styles or create a new one in Pages, Numbers, or Keynote, on Mac, iPhone, and iPad.
How to combine and break up shapes in Pages, Numbers, and Keynote
Wondering how to merge shapes in Pages or break up shapes in Keynote? This tutorial shows you how to combine and break apart shapes in iWork apps on Mac, iPhone, and iPad.
How to fill shapes with colors, gradients, or images in Pages, Numbers, and Keynote
Learn how to fill shapes with specific colors, nifty gradients, or photos in the Pages, Numbers, and Keynote apps on Mac, iPhone, and iPad to make them more meaningful or beautify their appearance.
How to add caption and title for objects in Pages, Numbers, and Keynote
Learn how to create captions & titles for photos, videos, and other objects in Pages, Numbers, and Keynote to give your audience descriptions, include citations or references, or simply help articulate your object better.