We'll show you how to create an Excel checklist with checkboxes you can tick off as you complete the items. It will indicate when you've checked off all the items so you can tell at a glance.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE() function.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

Image: AndreyPopov, Getty Images/iStockphoto. The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news is that identifying a list on ...

You can use Excel formulas, for example, to create a simple drop down list. You can even create a dynamic drop down list that can easily be extended when necessary. But, that’s a tutorial for ...