Microsoft has updated its Office for iPhone and iPad productivity suite with a few new nice-to-haves. For instance, you can now take advantage of side-by-side multitasking in Excel. Also, Word now supports richer mouse and trackpad interactions on your Magic Keyboard.
Excel
How to extract photos and images from Pages, Word, Excel, and more
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.
Microsoft is rolling out full iPadOS trackpad support in Word, Excel, and PowerPoint
Not too long ago, Microsoft confirmed that it planned to rollout full trackpad support in iPadOS before the end of 2020 for Word, Excel, and PowerPoint. And the company has kept its word.
Keyboard shortcuts for Microsoft Excel on Mac
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
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 launches the new Office iPhone app that consolidates Word, Excel, and PowerPoint
Back in November of last year, Microsoft began beta testing a new version of its Office app for iPhone, one that consolidates Word, Excel, and PowerPoint into one app experience.
Microsoft consolidates Word, Excel and PowerPoint in Office Mobile
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.
Excel for iOS now lets you import printed data by scanning a physical piece of paper
Microsoft yesterday announced a cool table-creation feature in Excel for iPhone and iPad which takes advantage of your iOS device's built-in camera, computer vision and machine learning to turn a photo of data in a table format into an editable spreadsheet in the app.
Trackpad sketching now available in Microsoft Word, Excel & PowerPoint for Mac
Microsoft today refreshed its Word, Excel and PowerPoint productivity apps in Mac App Store with support for trackpad-based sketching.
How to convert a Numbers file to Excel on Mac, iPhone, and iPad
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
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
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.