Data

Visible now supports cellular Apple Watches for just $5 per month

Around three months ago, I shared my user experience with Visible as a second carrier for my iPhone. Visible, which operates on the Verizon Wireless network, offers outstanding network coverage for as little as $25 per month with unlimited 4G LTE & 5G data, talk, and text, and with unlimited tethering included!

Just this past week, however, Visible did something I never saw coming. They added support for cellular-capable Apple Watches. And much like Visible’s hyper-affordable cellular plan, enjoying cellular connectivity with Visible is just as affordable.

How to insert and format charts in Pages

Pie Chart in Pages on Mac

We mostly think about using charts when working in an application like Numbers. After all, that’s where we use a lot of numerical data and perform data analysis. But if you’re creating a report, proposal, or similar document where a chart could be beneficial, Pages has you covered.

What’s nice about the chart feature in Pages is that you can just pop in a chart, add a small amount of data, and you’re done. If you want to spruce it up, you can, but you don’t have to.

To make your next document a little more eye-catching, we’ll show you how to work with charts in Pages.

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

Insert Format and Edit a Chart in Numbers on Mac

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 color alternating rows in your Numbers sheets

Alternating Rows Orange in Numbers on Mac

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 create and use forms for data entry in Numbers on iOS

Create a New Form in Numbers on iPad

Working with a spreadsheet isn’t particularly difficult if you’re just entering data yourself. But if you’re collecting information from other people or just want an even simpler way to input data, you can use a form. Numbers version 10.2 on iPhone and iPad has a nice form feature that you’ll appreciate.

Basically, you create form, link it to a table, and then use the form for your data entry. And if you use Numbers on iPad with Apple Pencil, you can take advantage of handwriting data in the form too. So, if you’re ready to make data entry on your device easier, here’s how to create and use forms in Numbers.

How to use Data Detectors and Shape Recognition on iPad

Data Detector iPad Phone Number

Apple’s "on-device intelligence" is used in a variety of forms. From Smart Stacks and Siri Suggestion widgets to the Translate app to Accessibility recognition features, your device continues to learn from your actions and patterns. Using that same technology, upgrades to iPadOS 14 in combination with Scribble let you do things easier on your iPad.

If you use your Apple Pencil for handwritten notes and shapes, you can take advantage of your iPad’s smarts with Data Detectors and Shape Recognition. Each of these make capturing notes that you want to save or share simpler for others to read or for you to act on.

Here, we’ll explain Data Detectors and Shape Recognition and how they work on iPad with Scribble to help you.

How to work with basic Categories in Numbers on Mac

Numbers Mac Basic Categories

Apple Numbers gives you various features for viewing and analyzing your data. Once such feature is called a Category. With categories you can arrange your data into groups. This lets you see specific data sets in a new way. In addition, you can create subcategories to further identify the data you need.

For example, say you have a Numbers spreadsheet for real estate. You want to group together homes with five bedrooms, four bedrooms, and so on. And within those bedroom groups, you want those with five bathrooms, four bathrooms, and so on. Using categories, you can create these groups and subgroups to then show those houses your client is looking for.

This is just one example of how categories can help you in Numbers; there are plenty of other situations where this feature comes in handy. To get started, this tutorial shows you how to work with basic categories in Numbers on Mac.

How to sort your data in Apple Numbers on Mac

Numbers Sort Data 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.

Numbers 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.

Sorting in Apple Numbers on Mac

Quick sorting in ascending or descending order

Two very common ways are sort in ascending or descending order. And these can apply to numbers, text, dates, or blank cells. For this reason, these two sorting options are handily placed in the shortcut menus for your columns.

You’ll first choose the column you want to sort by, keeping in mind that all data in your table will adjust accordingly. If you only want specific rows to be affected by the sort order you choose, you’ll do that by setting up a rule, which we explain later in this how-to.

1) Select your column and then click the arrow next to the header.

2) Choose either Sort Ascending or Sort Descending.

You’ll immediately see the data in your table shift per the sort order for that column.

Remember, you can use the Edit > Undo action in the menu bar to undo the sort if it’s not what you expected.

Setting up a sort rule

If you want to sort your table by more than one column or only apply sorting to certain rows, you can set up a sort rule. You’ll do this in the right-hand sidebar in Numbers and can open it one of these ways.

Click Organize > Show Sort Options from the menu bar. Click the arrow next to any column header and pick Show Sort Options from the shortcut menu. Click the Organize button on the top right of Numbers and choose the Sort tab in the sidebar.

Now that you know how to open the area to create a sort rule, it’s time to get to work.

Sort an entire table

You may want to sort your whole table based on multiple columns. For example, you might want to sort by date and then by name, by dollar amount and then by product, or something similar.

1) Confirm that the top drop-down box set to Sort Entire Table.

2) Choose the first column you want to sort by in the drop-down box.

3) Select Ascending or Descending order for that column.

4) Choose the second column you want to sort by in the next drop-down box and then select its order too.

5) The table should sort for you automatically, but to make sure you can click Sort Now at the top of the sidebar.

To remove one of the columns from the sort rule, click the Trash Can next to it.

To change the order of the columns you’re sorting by, click the three lines to the left and drag it to its new location in the sort order rule.

Sort selected rows

If you want to only sort specific rows in your table, you can create a sort rule for this just as easily as sorting a table.

1) Select the rows you want to sort.

For adjacent rows, either drag through them or click the first, hold down Shift, and then click the last in the range.

For non-adjacent rows, click the first, hold down Command, and click each of the remaining rows.

2) In the sidebar, choose Sort Selected Rows in the drop-down box.

3) Continue setting up your rule with the same Steps 2 through 5 above to add the columns and order.

Caution: Be very careful when sorting by selected rows only since it will not adjust the rest of the data in your table. And, keep the Edit > Undo action from the menu bar in mind if you need to undo the sort.

Wrapping it up

Sorting data in Numbers is easy to do and you have flexibility with the columns and order you want to sort by. Have you run into any trouble using the sort options in Numbers? Let us know below or send us a message on Twitter.

For more, check out how to create and use Interactive Charts or add style to your Numbers tables.

How to filter your data in Apple Numbers on Mac

Use Filters in Apple Numbers 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 and have the data you need. This tutorial shows you how to filter your data in Apple Numbers.