Create a Menu — In this brief tutorial, I explain how to create a menu that contains a handful of frequently used commands. (I use Word in this tutorial; the procedure is nearly identical with Excel ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

How to Create Pulldowns in Excel. You can create a pull-down menu in Microsoft Excel 2010 by configuring a list of values in the Data Validation menu.

You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.