Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Customize the Ribbon in Excel 2013

In this video you’ll learn how to customize the Ribbon in Excel. The Ribbon is the menu at the top. Adding new tabs with commands you use often will let you access them at all times, saving you time and effort.

To start, right-click the Ribbon and click on Customize the Ribbon… from the drop-down menu.
In the dialog box, select New Tab from the options on the right.
Make sure New Group is selected.
Select a command.
Click Add.
You can also drag and drop commands into a group.
When you have added all the commands you want in the ribbon, click OK. The commands you selected will now appear in the ribbon.
To see all the available commands, go to Choose commands from on the left.
Select All Commands from the drop-down menu.
To remove a command, right-click on the ribbon, click Remove commands, click on the command (and the new group if you wish to remove it), click remove and then OK.