Creating Your Own Menu

Excel 365 2016 2013 2007 2003
Creating custom menus in Excel is a funny feature you can use to create groups of the options that you use most often, and then plug them into the menu you name and use yourself.

To create a new tab (ribbon), new group in existing tab or add a new command in the ribbon, follow next steps:

   1.    On the File tab, click the Options button:

Excel 2010 Options

   2.    In the Excel Options dialog box, select the Customize Ribbon tab:

Customize the Ribbon in Excel 2010

   3.    To create a new tab, select the tab, after which you want to insert the new tab and then click the New Tab button:

New Tab in Excel 2010

To rename a tab, select it and click the Rename... button or right-click in it and choose Rename in the popup menu:

Tabs popup in Excel 2010

   4.    To create a new group in the tab (when you create the new tab, one group will be created automatically), select the group, after which you want to insert the new group, and then click the New Group button.

To rename the group, select it and click the Rename... button or right-click on it and choose Rename in the popup menu:

Rename the group in Excel 2010

To remove the group, right-click on it and choose Remove in the popup menu:

Groups popup in Excel 2010

   5.    To add a command to the group:

  1. In the Choose commands from area, select the command, which you want to add to the group:
    Add command in the group in Excel 2010

    Use the Choose commands from menu to display more commands:
    All commands

    Press the first letter to jump down to the commands that begin with this letter. You will need less scrolling to get to the command you want to add.
  2. Click the Add > > button.

To rename the command, select it and click the Rename... button or right-click on it and choose Rename in the popup menu. To remove the command, select it and click the < < Remove button (under Add > >) or right-click on it and choose Remove in the popup menu.

   6.    Click OK to close the Excel Options dialog box.

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.