MacMost: Numbers

Understanding Numbers Column References
5/8/23
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.
How Cell References Automatically Adjust in Numbers
4/24/23
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.
10 Ways To Use Checkboxes In Numbers
4/11/23
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.
Understanding CSV Files
4/10/23
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.
How To Print a Portion of a Page on a Mac
4/4/23
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.
New Export Options In Pages
4/3/23
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.
How to Use Conditional Highlighting In Numbers For Data Visualization
3/16/23
You can use Conditional Highlighting to make numbers stand out in your spreadsheets. If you combine them with functions like RANK, LARGE, SMALL and more you can see useful information in your tables at a glance.
The 7 Skills You Need To Learn To Master Numbers
3/3/23
In order to use Numbers to its fullest, first master these essential skills before worrying about functions.
Using Images in Mac Numbers Spreadsheets
2/15/23
You can use photos and other images in your Numbers spreadsheets, but not as values in cells. Learn how you can decorate a sheet with them, or use them in a clever way in a table to display a featured image.
How To Convert Words and Names To Values in Numbers With IF, SWITCH and LOOKUP
12/2/22
If you have names, product IDs or some other words and need to translate those to number values you can do it with the IF, IFS, SWITCH or LOOKUP functions in Numbers. While the first functions are good for small limited lists of values, only the LOOKUP function works well with a large list that changes often.
10 Useful Mac Numbers Templates
10/21/22
Numbers comes with a variety of useful templates. You can use these in your daily life, or dissect them to learn how they work and learn some spreadsheet skills.
How To Use Autofill In Mac Numbers
10/4/22
You can autofill cells in Numbers using copy and paste, a special autofill feature, and by simply adding new rows to a well-formed table. With the autofill feature, you can have values increase by 1, or using a pattern.
Calculating Difficult Dates In Mac Numbers
9/22/22

Learn how to calculate dates like the first or last day of a month, the first or last day-of-week of a month, or the nth day-of-week of a month.

Mac Numbers Conditional Highlighting and Alternatives
9/9/22
You can use Conditional Highlighting in Numbers to make values stand out. You can also use alternatives like formulas in other columns or custom formats. Also learn how to have cells highlight based on the value of a different cell.
Learn How To Use Pivot Tables In Numbers By Example
8/29/22
If Pivot Tables in Numbers seem intimidating, watch this tutorial to see how easy they are to use. You can get a lot of information without ever needing to using functions or formulas.
Printing Labels Using Mac Pages
8/1/22
You can easily create a simple labels template to print a list of addresses to labels in Pages. The list can come from text or a Number spreadsheet. You can also modify pre-made labels templates to work better.
Calculating Rank In Mac Numbers
7/11/22
If you need to find the ranking of rows in Numbers, you can sort, use COUNTIF or use RANK. It gets a little more complex if you have to use multiple values for tie-breakers or rank within groups.
5 Ways To Generate Random Numbers On Your Mac
7/6/22
Learn how to get random numbers on your Mac using the Calculator app, the Numbers app, Siri, the Terminal and a custom Shortcut.
Quick Calculations In Mac Numbers
6/7/22
You can get the sum, average and perform other calculations on selected cells without needing to create a formula in another cell. The Quick Calculations appear at the bottom of the Numbers window whenever you have more than one cell selected. They also can be dragged-and-dropped to create permanent formulas and will obey filters.
Using Shortcuts To Add Data To a Numbers Spreadsheet
4/21/22
A new action in Shortcuts for Mac allows you to add a row of data to a Numbers spreadsheet. You can prompt for information and then record a time and some data. Numbers version 12 is required. An older technique allows you to change existing data in a Numbers spreadsheet.