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.

Windows 95 returns as a Mac app

You can now load up Windows 95 on your Mac and mess with File Manager, play the classic games Solitaire and Minesweeper or just marvel at the piece of software that has helped Microsoft win the desktop wars of the 1990s and nearly killed the Macintosh platform.

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.