In this tutorial, I’ll show you how to populate a dropdown with data on another sheet. I’m using Microsoft 365 desktop on a Windows 10 64-bit system, but you can use older .xlsx versions.

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

Why wade through endless choices? Refine your lists on the fly with dynamic dropdown lists.

This tutorial on Microsoft Excel covers all the basic features, tips & tricks on how to use and create an Excel worksheet. Learn Excel quickly!