Creating a dropdown list in your Excel spreadsheet can help to increase the efficiency of your work. This might come in handy, especially when you want your coworkers to provide certain information ...

Remember the rules on naming cells, you will find that in my previous tip on naming ranges in Excel. How to set the dropdown list to a cell or a range of cells Now that you have your named list on a ...

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

One typical application for Excel is to find information in a list of data. The simplest way to do this is filtering the data so that Excel does the work of finding the pertinent information for you ...

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Excel adds filtering controls to column headers automatically. When you click the arrow, Excel displays a pop-up window with a list of filtering controls available for your list.