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.

Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula.

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.

How to generate a list of hyperlinks in Excel. It’s not unusual for a complex workbook to include a list of hyperlinks to each sheet in the workbook. The procedure you’ll use, ...

In my example, 50 appeared in the list three times, and 19 appeared twice, so Excel has removed two 50s and one 19, totaling four duplicate removals overall. Click "OK" to close this message.