MacMost: Archives

When building Numbers spreadsheets it is important to remember that a row in a table is the equivalent to a record in a database. To build a billing system, you can put clients in one table and invoice items such as billable hours in another table. Then you can build a sheet with tables that use functions to populate an invoice. You can use the new FILTER function for this.

Your Mac may come with a mix of Thunderbolt and USB ports. What are the differences and when should you use each? How about the HDMI port?

There are many ways you can perform math calculations on your Mac. Some are quick and easy, some are for special situations, and others are can be combined with automations.

Here are some ways to customize how your Mac looks without needing to spend a lot of time. You can change a variety of settings with just a switch or by making a few choices.

The Dock is an important part of macOS that allows you to quickly launch apps and access files. You can customize the Dock to include what you want.

If you see numbers or boxes on your screen, don't hear any sound, can't use some keys or your Mac wakes up from sleep on its own, there may be a simple explanation and an easy fix.

Here are 5 ways you can create lists on your Mac that allow you to reorder lines and indent items.

If you have Safari set to ask you where to save a file each time you download it, but it isn't asking, you are not alone. Here are two ways to work around this bug.

While many people use tabs with browsers, they can also be very useful in document apps like Pages and Numbers. Here's how to get the most from tabs.

If you need to crop an image down to specific dimensions, change it to another file type, or compress it to be under a certain size, you can do that all with Pixelmator Pro relatively easily.

The new Mail Inbox Categories feature helps you get through your inbox by dividing messages into separate categories. You can manually control which senders end up in which categories. You also have two ways to view your inbox as it looked before.

The new Ambient Music feature allows you to add buttons to Control Center or your Lock Screen to quickly start playing music from specific playlists.

If you like a clean email inbox, the Mac Mail "Remind Me" feature can help. It allows you to set a reminder in the Mail app for a message that will work to alert you and bring the message back into your inbox even after you archive it.

If you are using an input source setting that doesn't match your physical keyboard, it can be hard to figure out how to type some basic characters. Here's how to check to see exactly what character each key on your keyboard maps to.

You can use Pixelmator Pro to edit your photos directly from the Photos App. You can do simple repairs, or make selections to change only one part of the photo. You can even use layers and store those layers inside your Photos library.

If you want to focus on a single task to get as much work done as possible, you can use a variety of techniques on your Mac to help.

Pages allows you to easily create a variety of different types of lists in your document. Knowing a few techniques and shortcuts can help you create even more complex lists that look exactly like you want.

If you need to figure out which items in your Mac Photos Library are taking up the most space, you can't do it in the Photos app. But you can create a simple Shortcut to examine the photos and videos in your library and create an album showing you the largest items.

If you save a new file or download something and now can't find it, this is the video for you. You'll learn how to save and download files to locations to make them easier to find, and also how to find files you already saved but now can't locate.

Here are some tips to help you master the Notes app on your Mac. Learn how to add tags, link to other notes, resize images, highlight text and much more.