Forum Discussion

Norez_Abdullah's avatar
Norez_Abdullah
Copper Contributor
Feb 20, 2024

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

 

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 

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.

    • Norez_Abdullah's avatar
      Norez_Abdullah
      Copper Contributor

      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.

    • ShirleyDW's avatar
      ShirleyDW
      Copper Contributor
      Hi I do not have a "manage styles" option. Only new cell styles and merge cells at the bottom of the list. I want to hide the ones I don't use but am not able to follow the instructions above - how do I do this please?

Resources