If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need ...

How to run a VBA procedure from a data validation control in Microsoft Excel Your email has been sent There are lots of ways to execute a VBA procedure in Microsoft Excel. You can add macro buttons at ...

This is my simple way to use the VLOOKUP function in Excel to find data fast. I walk through how I use VLOOKUP to look up ...