Excel

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

Sandy Writtenhouse ∙ September 24, 2018

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

Sandy Writtenhouse ∙ Updated October 15, 2018

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.

How to create drop-down lists in Excel on Mac

Sandy Writtenhouse ∙ Updated March 28, 2022

Using custom lists in Microsoft Excel on your Mac makes tedious data entry relatively quick and easy. Drop-down lists are no different; you can create one in just a few clicks.

Drop-down lists in Excel are ideal for limiting the options for cell entries. They come in handy for selecting items like colors, sizes, products, people, days, and so much more.

Here’s how to quickly create a drop-down list in Excel on Mac.

How to create reusable custom lists in Excel on Mac

Sandy Writtenhouse ∙ August 30, 2018

Along with its robust features like automatic calculations, conditional formatting, charts, and such, Microsoft Excel offers some simple features that can save you time.

One of these features is the ability to create custom lists. Custom lists can be used over and over on your spreadsheets. This is handy for things you use often like product, employee, or attribute lists.

Here’s how to easily create and use custom lists in Excel.

Microsoft’s mobile Office apps pick up support for drawing with a finger/stylus on iPhone

Christian Zibreg ∙ August 15, 2016

Microsoft today issued updates to its mobile Word, Excel and PowerPoint apps on the App Store, adding support for drawing with your finger on the iPhone. Back in January 2016, the Windows maker brought its inking tools to the iPad Pro with Apple Pencil support. With the latest update, iPhone owners can take advantage of the Draw tab to draw, highlight and annotate documents with their finger or a stylus.

How to export your iPhone contacts to an Excel, CSV, or vCard file

Sébastien Page ∙ Updated July 21, 2025

Learn how to export your iPhone contacts as an Excel, CSV, or vCard file to use as a backup or to share them with someone else.

Microsoft Office apps updated with support for exporting files in OpenDocument format

Christian Zibreg ∙ June 13, 2016

Ahead of WWDC keynote at 10am this morning, Microsoft refreshed its trio of Office productivity applications for the iPhone, iPod touch and iPad with a notable new export option. Word, Excel and PowerPoint apps can now export documents, spreadsheets and presentations in the cross-platform OpenDocument format, making the mobile apps even more suited for business use.

Microsoft updates Office for iOS with 3D Touch features, Apple Pencil support and more

Christian Zibreg ∙ January 21, 2016

Microsoft today rolled out updates to its mobile Office suite in the App Store: Word, Excel, PowerPoint and OneNote. Across the board these apps have gained support for 3D Touch shortcuts on the iPhone 6s/Plus.

In addition, the new 'Annotate with Ink' feature puts a set of cool tools on the new Draw tab for drawing, writing and highlighting things using touch, pen or Apple Pencil on the iPad Pro.

Microsoft refreshes Office apps for iPad Pro, with an important caveat

Christian Zibreg ∙ November 11, 2015

Windows giant Microsoft today released compatibility updates for its mobile Office app in the App Store—Word, Excel, PowerPoint, Outlook, OneNote and OneDrive—aimed at lucky iPad Pro owners.

Featuring full support for iOS 9's new Slide Over and Split View multitasking modes, these apps now take full advantage of the iPad Pro's massive 2,732-by-2,048 pixel resolution 12.9-canvas that in landscape mode basically runs two full-sized apps concurrently.

Microsoft Office apps pick up better Outlook integration with ‘Send with Outlook’ and more

Christian Zibreg ∙ August 12, 2015

Microsoft today issued refreshed Word, Excel and PowerPoint applications for the iPhone, iPod touch and iPad in the App Store. The new versions of these mobile productivity apps include several new features, most notably tighter integration with Microsoft's Outlook for iOS app.

In addition to richer Outlook integration across all three apps, you can now change selected text in Word to uppercase, lowercase, sentence case and more, as well as view comments in PowerPoint next to the slide in a task pane.

Office for iOS gains Outlook integration, easier sharing, viewing protected files and more

Christian Zibreg ∙ July 23, 2015

Software giant Microsoft on Thursday issued a set of updates adding several new features to its Office mobile apps on the iOS platform. For starters, the refreshed editions of Word, Excel and PowerPoint for the iPhone and iPad can finally open and view protected documents.

Next, users can now easily invite others to collaborate on documents and grant permissions from within the apps, another important productivity boost.

Microsoft Office apps for iPhone and iPad gain iCloud document support and other perks

Christian Zibreg ∙ Updated January 28, 2016

Microsoft's free of charge Word, Excel and PowerPoint productivity applications for the iPhone and iPad have been updated with the ability to open, edit and save your documents to iCloud, expanding on the previously available storage options such as Microsoft's own OneDrive cloud storage and Dropbox integration.