How to remove undesired cell styles (in home tab) from office 365 standard version of excel?

Copper Contributor

 

Hi,

 

Any clues about removing undesired cell styles (in home tab) from office 365 standard version of excel? the drop down feature is not visible neither right click delete option on the style itself is working?

 

Thanks

 

Norez 

3 Replies

@Norez_Abdullah 

In Excel, the built-in cell styles cannot be deleted or removed directly. However, you can modify them to suit your needs or create custom styles. Here's how you can manage cell styles in Excel:

  1. Modify Existing Styles:
    • Go to the "Home" tab on the Excel ribbon.
    • In the "Styles" group, click on the "Cell Styles" dropdown arrow.
    • Hover over the style you want to modify and right-click on it.
    • Select "Modify" from the context menu.
    • In the "Style" dialog box, make changes to the formatting options as needed.
    • Click "OK" to apply the modifications.
  2. Create Custom Styles:
    • Go to the "Home" tab on the Excel ribbon.
    • In the "Styles" group, click on the "Cell Styles" dropdown arrow.
    • Click on "New Cell Style" at the bottom of the dropdown list.
    • In the "Style" dialog box, specify a name for your custom style.
    • Set the desired formatting options for your custom style.
    • Click "OK" to create the custom style.
  3. Hide Unused Styles:
    • Unfortunately, Excel doesn't provide a direct option to delete built-in styles. However, you can hide the unused styles to declutter the list:
      • Go to the "Home" tab on the Excel ribbon.
      • In the "Styles" group, click on the "Cell Styles" dropdown arrow.
      • At the bottom of the dropdown list, click on "Manage Styles".
      • In the "Style Manager" dialog box, switch to the "Used" tab.
      • Select the styles you want to hide by unchecking the checkboxes next to them.
      • Click "OK" to hide the selected styles.
  4. Using VBA:
    • If you're comfortable with VBA, you can write a macro to delete or modify built-in styles. However, this approach requires some programming knowledge and should be used with caution.

Remember to always save your workbook before making significant changes to cell styles or using VBA. Additionally, it's a good practice to create a backup of your workbook in case anything goes wrong during the modification process. The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

@NikolinoDE thanks for the reply, helpful. i am comfortable with the programming code and wish to remove the custom styles only, i don't have issues with the built-in styles being there.

@Norez_Abdullah 

Will it work if you add this Style

image.png

button into Quick Access Toolbar and try to remove from it?

image.png