Numbers

How to add stock quotes and information to your Numbers sheet

Stock Quotes in Numbers on Mac

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.

How to extract photos and images from Pages, Word, Excel, and more

Word Save as Picture on Mac

Have you ever received or downloaded a document that you wanted to grab an image from? It could be your company logo in a Pages document, photo of a location in Word, or an instructional image in a Keynote or PowerPoint presentation.

For the most part, extracting a photo or image from Apple and Microsoft applications is universal, which is nice. Here, we’ll show you how to extract a photo or image from various document types.

Tips for using Scribble in Pages, Numbers, and Keynote on iPad

Try Scribble on iPad

Scribble is a terrific tool for jotting down notes on your iPad with an Apple Pencil. With iPadOS 14, you can do things like turn handwriting into typed text and use handwriting in text boxes like search fields.

So when it comes to being productive with Pages, Numbers, and Keynote on iPad, you can use Scribble to get things done quickly. Here are some tips for using Scribble in those apps with your Apple Pencil so you can make the most of the feature.

How to edit, animate, and share drawings in Pages, Numbers, and Keynote

Animate Drawing Options in Pages on iPad

You don’t have to be a professional artist to enjoy the benefits of drawing on your devices. And with or without an Apple Pencil, you can use Scribble to sketch or draw whatever you need. On iPhone, you can use your finger to sketch things like shapes and on iPad, you can expand your drawings with that larger screen.

You have plenty of tools to create drawings along with great ways to enhance them. Move or resize, edit or animate, and share your drawings with coworkers or pals. Here, we’ll show you how to do all of this with your drawings in Pages, Numbers, and Keynote on 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 find the serial numbers for your Apple TV and Siri Remote

Apple TV and Siri Remote from Pixabay

If you have to perform some troubleshooting on your Apple TV or Siri Remote, having the serial number is important. This not only helps to identify the model or type of device you own, but can help you get answers to questions about the specific device.

Here, we’ll show you how to get the serial numbers for both your Apple TV and Siri Remote.

Keyboard shortcuts for Microsoft Excel on Mac

MacBook keyboard-Excel keyboard shortcuts

Do you use Microsoft Excel on your Mac instead of or in addition to Apple Numbers? If so, knowing some keyboard shortcuts for Excel on Mac can save you time when performing basic tasks in your spreadsheets and workbooks.

As Microsoft products, Excel, Word, and PowerPoint have some of the same shortcuts. But most below are specific to using Microsoft Excel and will make managing your data a breeze.

How to lock tables and workbooks in Numbers

Numbers iPhone Locked Table

Numbers is a great option for spreadsheets and workbooks on iOS and Mac. As an alternative to Microsoft Excel, Apple Numbers has some of the same handy features but is lacking in others. So if you’re interested in locking cells in Numbers or locking an entire workbook, both to prevent unwanted changes, we’ll show you your options.

How to use Reading View in Pages, Numbers and Keynote on iOS

Reading View in Pages iPhone

If you’ve ever been reviewing one of your documents on iPhone or iPad and accidentally edited something, you’ll appreciate the Reading View feature. In version 10.1 of Pages, Numbers, and Keynote for iOS, you can enter Reading View to prevent unwanted and accidental changes to your documents.

Here, we’ll show you how to use Reading View in Pages, Numbers, and Keynote on your iPhone and iPad.

Keyboard shortcuts for Numbers on Mac

Mac Apple Keyboard - Numbers keyboard shortcuts

A lot of the keyboard shortcuts available for apps on Mac are the same across those applications. Things like cut, copy, paste, close, or quit are often times the same, especially for Apple’s apps like Pages, Numbers, and Keynote.

So in this list of keyboard shortcuts for Numbers, we’ve included some that you would only by using in Numbers; shortcuts for working with tables. But you’ll also find the basics for controlling the Numbers window and working in spreadsheets.

How to play YouTube and Vimeo videos in Pages and Numbers

Pages Mac Resize Video

You might be used to embedding videos in your Keynote slideshows, but what about adding them in Pages or Numbers? An update to these two apps lets you play YouTube and Vimeo videos right within your documents.

The feature was added to Pages and Numbers, versions 10.1, for both Mac and iOS. And it’s sure to be a handy one for all sorts of documents and spreadsheets, especially for business and education.

Here, we’ll walk you through how to add and then play YouTube and Vimeo videos in Pages and Numbers on your devices.

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.