Searchable Drop-Down Lists in Excel

It takes ZERO effort to now get searchable drop-down lists in Excel. Excel's data validation list now offers autocomplete by default. Empty cells are skipped too! This is all for desktop and online version. Check out this post to find out more.

Google Sheets IMPORTRANGE Function

Learn how to use IMPORTRANGE in Google Sheets. This function is great when you'd like to import data from other spreadsheets. You can also use it together with QUERY to import and append data from multiple sheets.

Google Sheets Dependent Drop-Down Lists

Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can't add a formula to the drop-down version of the data validation. But there is another way.

Google Sheets vs Excel

Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.

Multiple Searchable Drop-Down Lists in Excel

Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it easier to find an item from a large data validation list. We finally get to make this with simple formulas.

Excel Dependent Drop Down Lists on Every Row

Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.

Reset Dependent Drop-down in Excel

Reset Dependent Drop-down in Excel (with a tiny bit of VBA) Learn how to reset a dependent drop-down list in Excel with a little bit of VBA. The problem we get with dependent data validation lists is that when you change the value