Recent Articles

If you're working in Google Sheets, here's how to add drop down menus that allow for multiple selections.
Google Sheets Tips

How to Make Multiple Selection Drop-Down Lists in Google Sheets

I often want to select more than one option in a drop-down list. For example, when thereโ€™s a collection of colors to choose from, I might like more than one color. Or, in a document where we list proficiencies, I might want to choose more than one from a list of coding languages. In cases where my employee has multiple skills, I want to select multiple options from the drop-down.

Read More ยป
Highlight duplicates in Google Sheets with a single formula.
Google Sheets Tips

How To Highlight Duplicates in Google Sheets

Highlighting duplicates in Google Sheets takes one formula and a conditional formatting rule. This guide shows how to do it in a single column, across multiple columns, and for entire duplicate rows, including how to flag only the second occurrence, combine multiple conditions, and fix the two most common reasons the formula stops working.

Read More ยป

More Spreadsheet Expertise