How to Customize Your Excel Ribbon

The ribbon in Excel lies on the top of the workbook. And in this article, you will know how to customize the ribbon according to your need.

When you need to use a feature in Excel, you will certainly find it in the ribbon. The image below shows the ribbon in Excel.Ribbon

Even though the default setting can satisfy most of the needs in your work, you can also manage the ribbon by yourself.

Customize the Ribbon

Show or Hide Tabs

In this part, you can follow the steps and see how to hide or show tabs.

  1. Right click one of the tabs in the ribbon.
  2. And then choose the option “Customize the Ribbon” in the pop-up menu.Customize Ribbon
  3. Thus, you will open the “Excel Options” window. On the right part of this dialog, you can see the main tabs in the list. And all the default settings are included in this part. If you need to hide any of the tabs, you can uncheck the option. In addition, you can certainly check the option when you need to show them.Excel Options
  4. Here click the small arrow in the second text box. In the drop-down list, you can see the option “Tool Tabs”.Tool Tabs

When you choose this option, all the tool tabs will appear in the list. Here you can also choose to show or hide them according to your need.All Tool Tabs

  1. When you finish the setting, click the button “OK” in the “Excel Options” window to save the settings.

Add New Tab

In this part, you can follow the steps and add a new tab in the ribbon.

  1. In the “Excel Options” window, click the button “New Tab”. And then the new tab will appear in the list.
  2. Now click the new tab.
  3. After that, click the button “Rename” in the window.
  4. Next the “Rename” window will appear. Here you need to input the name of the new tab.
  5. And then click the button “OK” in the “Rename” window.
  6. Now click the two arrow button on the right to change the order of the new tab in Excel.
  7. After that, click the button “OK” in “Excel Options” window to save the settings.Add Tab

Now you will come back to the worksheet. You can see that the new tab will appear in the ribbon.

New Tab

Add New Group

Now it’s time to add new groups into tabs. Actually, you can also add new groups to the default tabs in Excel. Here we will use the new tab as an example. And the steps are the same if you need to add new groups to other tabs.

  1. In the “Excel Options” window, click the tab that you need to add the new group.
  2. And then click the button “New Group”.
  3. After that, click the new tab in the tab.
  4. Next click the button “Rename”.
  5. Now you will see the “Rename” window pop up. Here choose a symbol for the new group.
  6. And then input the name into the text box.
  7. Then click the button “OK”.
  8. Now you can click the two arrow button on the right to adjust the order.Add Group
  9. In the end, click “OK” to save the settings. Thus, in the ribbon, you can see the new group.

New Group

Add Features to Groups

When you have added new group into the ribbon, you can now add features to the tab.

  1. In the “Excel Options” window, click the custom group.
  2. Next choose the features in the left list.
  3. After that, click the button “Add”
  4. Now repeat the step 2 and step 3 and add other features into the group.
  5. When all the features that you need have been added to the group, click “OK” in the “Excel Options” window.Add Features

Now you will come back to the worksheet. In the ribbon, you can check the result.New Features

You need to remember that you can only add features to custom groups. If you accidentally add to one default group, you will see this information:Information

Hence, the next time don’t try to add features to the non-custom groups.

Save the Customizations

Sometimes you will reinstall Excel due to certain reasons. But the reinstallation will remove all the settings that you have made. In order to save the settings for the ribbon, you can export it.

  1. In the “Excel Options” window, click the button “Import/Export”.
  2. Next choose the option “Export all customizations” in the menu.Export
  3. In the “File Save” window, choose the path that you need to save.
  4. And then input the name for the customizations into the text box of “File name”.Save
  5. In the end, click the button “Save” to save the setting.

The next time when you need to import it into your Excel, you can follow the steps below.

  1. In the “Excel Options” window, click the button “Import/Export”.
  2. Now you should choose the first option “Import customization file”.
  3. Next in the window, choose the path where you have saved the file.
  4. And then choose the file.
  5. After that, click the button “Open” to open this file.Open Files
  6. Next you will see this dialog. Here click “Yes” to replace the existing ribbon.Yes
  7. Last, click “OK” in the “Excel Options” window to save the operation.

And now, you can use the customized ribbon again. You will never need to worry that you will lose your settings for the ribbon.

Change the Weak Password for Your Excel Files

Password is also a way to protect your Excel files. However, setting some simple passwords is not suggested. Those simple passwords can be easily cracked. At this moment, the passwords are actually useless. Therefore, you need to change those weak passwords into strong passwords. But even if you have strong password, your files are still facing the problem of being destroyed. And when your Excel files are destroyed by other people, you can repair Excel xls file damage by a third-party tool easily. With strong password and this wonderful tool, you can make sure that you will never lose data.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair Word doc and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.