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.

To select multiple items in a group in Excel hold Ctrl then select each item in the group. You can also select from multiple groups by holding Ctrl as you click.

Are you wondering how to use the Excel FILOTER function with multiple criteria? We have detailed guide on how to easily use the Filter function in Excel using the AND and OR operators.