Creating Your Own Menu

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

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Create a toolbar button or menu item to run a Macro

Create a toolbar button or menu item to run a Macro

If you assigned a key combination to a macro when you recorded it, you can run the macro by pressing that key combination. If not, you can subsequently assign the macro to the menu item.
Creating and using named ranges

Creating and using named ranges

Range names is a powerful Excel feature which allows you to give a symbolic name for the cell or range of cells to be later used as convenient replacement for cell/range address in formulas.
How to generate series of dates

How to generate series of dates

Often you'll want to insert a series of dates into a worksheet. The most efficient way to enter a series of dates doesn't require any formulas - just use Excel's AutoFill feature.