To open a menu and execute a command: Click on a menu name. The menu, complete with a list of commands, appears. With the menu open, drag the mouse pointer to a command and click on it. (As you drag your mouse pointer over the commands, each command is highlighted in light blue.) If there is a small black triangle next to a command, a cascading
Start Excel. On the Tools menu, point to Macro, and then click Visual Basic Editor. On the Insert menu, click Module. Type one of the macro examples from this article, or you can use a copy-and-paste operation to copy the macro examples to a module sheet. On the Run menu, click Run Sub/User Form. These shortcuts are for forcing Excel to (re)calculate formulas and can be very useful if your workbook is set to manual calculation mode. F9. (Re)Calculates all sheets in the active workbook. Shift + F9. (Re)Calculates the active sheet in the active workbook. Ctrl + Alt + F9. Select the cell with the drop-down list and press Ctrl + C to copy it. Select the cells where you want to add the dropdown. Right-click the selection, click Paste Special, and then select the Validation option. Alternatively, use the Paste Special > Validation shortcut, which is Ctrl + Alt + V, then N . Click OK. Whet your appetite for great design with menu templates. Make the most of every morsel of menu space—start your design with a customizable menu template. Menus let everyone know what you're serving up, whether it's haute cuisine or diner food, craft cocktails or smoothies, or something other than food altogether. 0HyjRcM.