Numbers

How to work with shapes and lines in Pages, Numbers, and Keynote

Sandy Writtenhouse / April 6, 2021

Pages, Numbers, and Keynote offer useful built-in shapes and lines that you can use to enhance your documents. Whether you’re creating a flowchart or diagram, or just want to add a subtle visual, you can easily insert and customize the available shapes and lines.

For converting straight lines to curved ones or adjusting a shape’s features, we want to help you make the most of using these items in your documents. Here are several tips for working with shapes and lines in Pages, Numbers, and Keynote.

How to add photos, music, or movies to Pages, Numbers, and Keynote documents

Sandy Writtenhouse / March 30, 2021

The Media Browser is exactly what it sounds like. It’s a tool for looking through or searching for media like photos, music, and movies. So if you want to include an item in your Pages, Numbers, or Keynote document on Mac, the Media Browser is your go-to tool.

Here, we’ll show you ways to access the Media Browser, find items with it, and insert media into your documents.

How to share documents from Pages, Numbers, and Keynote

Sandy Writtenhouse / March 26, 2021

When you finish working on a document in Pages, sheet in Numbers, or slideshow in Keynote, you may want to share it with someone. You don’t necessarily want to collaborate with them, which involves a different how-to for working on the document together. But you want to send it to them as a finished product.

You have various ways to share documents directly from Pages, Numbers, and Keynote along with different options when sharing it from Mac. So here, we’ll walk you through how to share a document on iPhone, iPad, and Mac.

How to collaborate in Pages, Numbers, and Keynote

Sandy Writtenhouse / March 25, 2021

You can easily share a document you create in Pages, Numbers, and Keynote. But that’s handier if your document is finished or you’re not looking for input. So if you’re composing a document that you want to work on with someone, these apps offer a nice collaboration feature.

When you collaborate, you’re working on it together and reviewing the other person’s input. You can use track changes or comments which is sort of like discussing it in the same room. This gives you an easy way to create the ultimate final product.

So here, we’ll show you how to start collaborating on your documents in Pages, Numbers, and Keynote. And we’ll go through instructions for Mac, iPhone, and iPad.

How to use zoom in Pages, Numbers, and Keynote

Sandy Writtenhouse / March 24, 2021

Zoom is one of those features meant to make our lives easier but is often overlooked for certain tasks. Sure, you may be used to zooming in on a photo your friend texts you, but do you think about the same action when you’re working on a document?

In Pages, Numbers, and Keynote on Mac, you can use the handy zoom feature in the toolbar. But there are also additional options for this feature in the menu bar. The functions differ per these three applications and between Mac and iPhone or iPad.

There’s never a reason to struggle to see something in these three apps with the helpful zoom option. So here, we’ll show you how to use zoom in Pages, Numbers, and Keynote.

How to add check boxes, sliders, and star ratings in Numbers

Sandy Writtenhouse / March 17, 2021

Numbers is more than a simple spreadsheet application. You can do things like create a form for data entry and insert interactive charts, in addition to tracking. Another great feature is the ability to add controls like check boxes, star ratings, pop-up menus, sliders, and steppers. These items give you easy ways to do data entry, fill out forms, and analyze your data.

Here, we’ll show you how to add each of these controls and adjust their settings to fit your needs. So if you want to add a check box, slider, star rating, or similar control in your next Numbers sheet, here’s how.

How to insert and fomat the current date and time in Numbers

Sandy Writtenhouse / March 16, 2021

How many times have you typed the current date or time into a Numbers sheet? You might be using a spreadsheet for tracking weight, a work schedule, or activities and enter the date each time you open it. Or, you might use Numbers for employees or team members and ask them to record the time they make their entries.

What’s nice about Numbers is that you can insert the current date and/or time without typing it in or using a formula to make it happen. You can also format both, here’s how.

How to insert, format, and edit charts and graphs in Numbers

Sandy Writtenhouse / March 9, 2021

Graphs and charts give you terrific ways to display data. Rather than reading row after row, a visual lets you see data at a glance, compare it, and even put it into perspective. And what’s nice about spreadsheet applications like Numbers is that all you have to do it select your data, pick out a chart, and the app will create it for you.

Once you have your chart, you can change its appearance and add items like a title, labels, and a legend. This gives you the flexibility to display a graph or chart that shows your data exactly as you like. So here, we’ll show you how to create your Numbers chart, format it to your liking, and edit it if needed.

How to apply conditional highlighting (formatting) in Numbers

Sandy Writtenhouse / March 8, 2021

If you’ve ever seen or used Conditional Formatting in Microsoft Excel, Apple Numbers offers the same type of feature. While labeled Conditional Highlighting, the feature works the same way. Based on rules you set up, cells in your sheet will automatically format a certain way.

So if you want all dollar values above a specific amount, dates between a certain range, or cells with missing data to appear highlighted, this is the feature you’ll use. Once you set up the conditions to look for, your sheet takes over to automatically format the data you specify.

This can be an extremely easy way to call out particular data or even locate errors in your spreadsheet. And because of the flexibility, the possibilities are almost endless for what you can automatically highlight. Here, we’ll show you how to apply conditional highlighting in Numbers on Mac, iPhone, and iPad.

How to wrap text in Numbers to display all your data

Sandy Writtenhouse / February 23, 2021

If you use text in your Numbers sheets, there may have been a time where that text was hidden by the cell to the right. And while you can select the cell and read the text at the bottom in Numbers on Mac, this isn’t always convenient. Plus, this isn’t an option in Numbers on iPhone or iPad.

Here, we’ll show you how to wrap the text in a cell in your spreadsheets. You can apply this formatting to a single cell, group of cells, column, and row. This will increase the height of the cell to display all text within it. But you if you resize the column or row containing the cell, the text will adjust.

How to color alternating rows in your Numbers sheets

Sandy Writtenhouse / February 22, 2021

When you have a large spreadsheet that’s full of data, especially numbers, it can be difficult to analyze without a little help. You might use a sort option or even a filter in Numbers to find certain data. But if you’re just reviewing it, why not make it a bit easier?

By coloring alternating rows, your sheets can look like those we’ve seen printed on pages. This feature simply uses a color to shade every other row. You’d be surprised at what a difference this makes to stay on track and not lose your place.

Here, we’ll show you how to color alternating rows in your Numbers sheets on both Mac and iOS.

How to add stock quotes and information to your Numbers sheet

Sandy Writtenhouse / February 18, 2021

If you want an easy way to keep track of your investments on Mac, consider using Numbers. With a handy built-in feature, you can add and update stock information in your spreadsheet.

As long as you’re connected to the internet, you can insert various performance details like price, high, low, open, previous close, and more. Here, we’ll show you how to use stock quotes in your Numbers sheets on Mac, iPhone, and iPad.