Mac

Stay up-to-date on the latest Mac news, and tutorials. Get expert tips and tricks to optimize your Mac’s performance and learn about the latest Apple products and software updates. Discover the best Mac apps and accessories to enhance your user experience.

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.

How to export notes from Evernote on Mac, iPhone, and iPad

Evernote Export a Note on Mac Screen

Evernote is a robust note-taking application with availability across multiple platforms, but it does have its limitations. For instance, the Evernote Basic plan only allows you to use the app on two devices for free. So, maybe you’ve decided to use another app in addition to Evernote. Or, maybe the time comes when you want to switch to a different note-taking app completely.

You can easily export notes from Evernote to a file that can then be imported to another note-taking application, and here’s how.

How to create drop-down lists in Excel on Mac

Excel drop down list on Mac

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

Excel Custom Lists Populated

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.

How to update the macOS software and install other Mac system updates in Mojave

macOS Mojave 10.14 has changed the way customers update the operating system software on their Mac. No longer do new over-the-air updates available for your computer appear listed underneath the Updates tab on Mac App Store. Instead, the Software Update mechanism now lives in its own place as a standalone preferences pane. This step-by-step tutorial will teach you how to update the macOS operating system on your Mac in macOS Mojave.

How to change text and formatting AutoCorrect settings in Word for Mac

Word AutoCorrect Options on Mac

Auto-correction is one of those features you either love or hate. We see it most in text messaging apps. And, it can be aggravating when you end up sending something in a message that you didn’t mean to, all because it was “automatically corrected” for you.

In Microsoft Word, however, the AutoCorrect feature can be quite useful. It can save you from errors, help you get your words out quicker, and format your document as you type. Here’s how to access, view, and adjust AutoCorrect settings in Word on Mac.