MacMost: Archives

When you copy and paste a formula in Numbers it doesn't just paste an exact duplicate of the formula. Instead, it adjusts the cell references based on the locations of the original and the new location. Learn why and how it does this, and how to modify this behavior to fir your needs.

It is fairly easy to find and type emoji and other special characters on your Mac. But you can also create a customizable list of favorites that are always available.

You can use Finder tags as a way to organize your files on your Mac and throughout iCloud Drive. Tags are more dynamic than folders since a file can only be in one folder, but can have many tags applied.

What's the right way to use your Downloads folder? How about the Trash or the Desktop folder? Take a look at different standard locations on your Mac and learn some best practices for using them.

AirDrop is the best way to transfer files between Apple devices in most cases. Learn why you should be using AirDrop instead of file sharing or cloud services for file transfer.

Any handheld video is going to be a little shaky. When building movies in iMovie or Final Cut Pro you can add video stabilization to your clips to smooth things out or even make some clips look like they were filmed using a tripod.

You can use Hot Corners on the iPhone and iPad just like you can on a Mac. However, the functionality depends on using a pointing device like a mouse and is meant more as an Accessibility function.

You can set your display resolution to what you think looks best for your eyes and your use. Don't let anyone tell you that you should only use a particular resolution and don't worry too much about the performance warning.

I believe many people don't make use of Notification Center Widgets and the reason could be because they show too much information. Instead, try forcing it to show you some specific information that you need throughout your day.

Checkboxes are a useful tool in Numbers that allow you to simply indicate a true or false value. You can use that as data, to sort, filter or alter the outcome of formulas.

CSV files are plain text files that contain spreadsheet data. They are useful for importing or saving data regardless of the spreadsheet app you are using.

Shortcuts doesn't seem to allow you to select menu items, simulate key presses or click buttons. But you can do those things with some scripting and add them to your Shortcuts that way. It takes some skill and patience to get what you want.

Learn how to use Smart Folders on your Mac and see some examples that you can put into use today.

Many people just switch to Full Screen mode when in an app without realizing how it works or what options are available. Learn how to better understand and control Full Screen windows on your Mac.

If you just want to print a portion of any document, you can jump from the Print Dialog to Preview very easily, select an area, crop or create a new document, and print that. You can also use this to share or save a portion of a document.

The new versions of Pages, Numbers and Keynote allow you to export the document and send it directly to someone else via email, AirDrop, Messages or other methods. This saves you the steps of needing to create an export file first and then attach it.

Here are 10 ways you can use ChatGPT to get things done or just for entertainment. Learn how to brainstorm, get book recommendations, improve something you wrote, create tables of data, plan your next trip or play a game.

You can easily mask images with basic or complex shapes in Keynote, Freeform, Pages and Numbers. You can also use multiple shapes in a mask by first uniting them. You can also use text as a mask by choosing the image as the color fill for the text.

Learn some keyboard shortcuts to speed up your Safari browsing experience.

If you need to change several image files at once, adjusting their sizes and maybe exporting in a new format, you can do it with Preview on your Mac.