Click the "OK" button to create the drop-down list for the selected cell or group of cells on the worksheet, or "Sheet2." Save the workbook. Hover over a cell to reveal the drop-down list box.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

These rules format cells based on their values. You can highlight cells with values above or below a specific number, between a numerical range, cells that match a specific value (number or text ...

How to Format a Row Based on the Value of a Cell in Excel 2007. Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might ...

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 to know.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.