Customize the Ribbon in Excel 2010 - Part 04 ( Reset , Export/Import the ribbon data)

Hello everyone,

In today post I'm going to write how to reset and export or import the ribbon data.
We have to use the Excel Options window to do this function also. Go to the "Excel Options" window and select the "Customize Ribbon" option.
Please see the below image and we need to use the red colour highlighted area to execute the above functions.

See the below image to find the inbuilt tab details.

These tabs will not be changed when we reset the tab data. Let's see how will the "Reset" option work.
We have already learnt how to add new tabs to the ribbon. To execute the reset option we need to add new tabs or new groups by changing the inbuilt data of the ribbon. Refer to the below image.

Ok. Now we just click on the reset button and see what will the result.

When we click on the "Reset" button, it will appear two options to yous how we need to reset the ribbon data. In the "Reset only selected Ribbon tab" option, we can choose some inbuilt tabs not to change their data.
And the "Reset all customizations" option, we can bring the ribbon to the inbuilt situation. It means this option will clear all the customization which you have done. Please refer to the below images.

Click on the "Reset all customization" option and then a message box will be appeared as below.

In this reset option the "Quick Access Toolbar" also be reset to the inbuilt situation.
After we click the "Yes" button the ribbon details will be changed as billow. Here you can see the ribbons which we have created are not there anymore.

Ok. The next option we have to learn is the "Import/Export" option.
Assume that you need to keep your ribbon changes as a backup before we reset the ribbon. Then you can be used this option. I will write about this option in the next post. Till then try this out yourself.