Step 3 - Select the option you required and click 'OK' to reset Excel Ribbon. Any custom Tab you had created before will be removed. Select Column (s) before Inserting a New Column. Change Microsoft Excel AppData with Windows Run Feature.

Selecting this option will reset Excel Quick Access Toolbar also. 9 Ways to Enable a Greyed out Insert Column Option in Excel.

'Reset only selected Ribbon tab' is greyed out (disabled) because no customization is made in Excel inbuilt Tabs (nothing to reset).Ģ) 'Reset all customizations' - If you select this option, you can reset all tabs on Excel Ribbon. You can see in above image 'Reset only selected Ribbon tab' is greyed out (disabled). You cannot reset any custom Tabs you had created. You can reset only inbuilt tabs to their original state if you select this option. You can see from the above image that there are two options.ġ) 'Reset only selected Ribbon tab' - If you select this option, you can reset select tabs to their original state.

Step 2 - Click on the down arrow in 'Reset' customizations split button, as shown below. Right-click anywhere on the 'Quick Access Toolbar' (except on 'Customize Quick Access Toolbar' drop-down button).Click the 'File' tab in Excel Ribbon and then click 'Options'.'Excel Options' window to customize Excel Ribbon can be opened by following methods also.

Excel ribbon is greyed out