Creating Your Own Menu

Excel 2016 2013 2010 2007
Creating custom menus in Excel is a fun feature you can use to create a list of the options you use most often, and then plug them into a menu you name and use yourself.

To create a new menu for your Excel menu bar, follow these steps:

   1.    Choose Tools -> Customize... to open the Customize dialog box.

   2.    Click the Commands tab.

   3.    In the Categories list, scroll down to choose New Menu:

New Menu in Excel 2003

   4.    In the Commands list, click New Menu, and then drag it to the Excel menu bar. The insertion point appears, showing you where the menu name will be placed.

   5.    With New Menu selected on the menu bar, click Modify Selection in the Commands tab in the Customize dialog box. Choose Name from the menu, and then type a name for the menu in the box.

   6.    In the new menu, click the menu command you want to move and drag it to a new location. Repeat as needed to move other commands in the menu.

   7.    Click Close to close the Customize dialog box. The new menu appears in the Excel menu bar at the top of your screen.

Note: If you want to remove a menu, press and hold Alt while dragging the menu name into the Excel work area. The menu name is deleted from the menu bar.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.