Posts By: Gary Rosenzweig

Instead of using a range of cells, you can refer to an entire column of cells by using just the letter for the column. But you need to be aware of how header and footer rows work first.

When you are looking at a Finder list of files, you can use your keyboard to jump to a file starting with that letter. But when you use multiple letters or have a non-alphabetical sort, it can be hard to understand why one file is chosen over another.

There are secret messages and fun images hidden throughout macOS.

The Desktop is a unique folder on your Mac that gives you quick access to the files and folders in it, providing other windows aren't in the way. Here are some ways to get to your Desktop items.

When using Apple apps and some third-party apps you can access a history of previously saved versions of the document. This is handy for reverting to an older version or bringing back delete content.

There are a few interesting settings in the Advanced section that you may want to check out.

A good alternative to online forums for tech help is to use the new AI chat sites. Since they draw on a large sample of online information, you can often get help quickly and easily ask follow-up questions.

You can create your own custom templates that have your letterhead at the top of the first page, all pages, or different letterhead for first and subsequent pages. You can then easily use this template to create future documents.

You can type Numbers formulas without your mouse or trackpad if you know how to use the Option key to select cells.

You can use connection lines in Pages, Numbers, Keynote and Freeform to create organization charts, diagrams, infographics and much more.

When you download an app from outside the App Store, you are taking a risk. But if you research the app and developer, ask your peers, check out their website and do the work, you can reduce the chance of any problems.

Learn how to switch on Keyboard Navigation to use the keyboard to navigate through dialog boxes and some app windows with just the keyboard instead of using a mouse or trackpad.

Here's a rundown of so many ways you can switch between windows and apps and why each one has its advantages and disadvantages. I even go to a third-party app that many people use just to get an highly customizable solution.

If you need your MacBook's battery to last as long as possible through a tough day, here are 13 ways you can save energy to get there.

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.

Here how I use drag-and-drop and a click to make it easier to work with save dialogs every day.

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.

Part of my "job" is to check the YouTube comments each day and try to keep up. This can take a lot of time and energy. Here's a sample of what it is like. This includes plenty of bits of info and tips as well.

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.