Excel

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

Extract photos from documents, spreadsheets, and presentations

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, a 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.

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 cells in Microsoft Excel on Mac to protect your data

How to Lock Cells in Excel on Mac

If you have an Excel spreadsheet or workbook that you want to either share with others, you likely have data that you don’t want them to be able to change. Maybe you want to allow them access to only edit certain cells. On the other hand, you may have data that you want to make sure doesn’t get accidentally changed as you work on the sheet yourself.

Unlike Numbers, you can lock cells in Microsoft Excel in a variety of ways. You can lock specific cells, cell ranges, rows, and columns. There are a few sets of steps in the process, but after you do it once, it will come easily for future workbooks. Here, we’ll walk you through how to lock cells in Microsoft Excel on Mac.

Microsoft consolidates Word, Excel and PowerPoint in Office Mobile

Mobile Office

For years Microsoft has offered mobile versions of its Office productivity suite. Today the company launched a public preview of Office Mobile, a new consolidated app that combines the functionality of Microsoft Word, Excel, and PowerPoint into a single unified experience. The public preview is capped at 10,000 users, though, so you might want to enroll quickly if you want access.

How to convert a Numbers file to Excel on Mac, iPhone, and iPad

Convert Numbers to Excel

While you may work and create your spreadsheets in Numbers, there may be a time when you need one of those documents in the Microsoft Excel file format.

You can easily export spreadsheets into different formats for viewing and editing with other applications. Here’s how to convert a Numbers file to Excel on Mac, iPhone, and iPad.

How to customize the Quick Access Toolbar in Word and Excel on Mac

Quick Access Toolbar Word

One nice thing about working with Microsoft applications like Word and Excel is that you can customize your tools. From the status bar at the bottom to the ribbon at the top, you can remove and add exactly what you need.

Another area you can customize is the Quick Access Toolbar. This is the small toolbar above your ribbon on the top left of the window. The point of this toolbar, as its name implies, is for quick access to tools you use most.

To help you make the most out of this area, this tutorial explains how to customize the Quick Access Toolbar to suit your specific needs.

How to transpose columns and rows in Microsoft Excel

Excel Transpose Group of Cells

When you use Microsoft Excel on your Mac for creating spreadsheets, you have plenty of layout options. But, sometimes it’s not until after you start entering your data that you wish you had structured the spreadsheet differently.

You may have entered column headers that would work better as row headers or vice versa. Luckily, you have a quick and easy way to make this type of switch with the Excel Transpose feature and here’s how to use it.