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

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.