Share via

How do I take a custom Excel table style and add it to the default Excel table styles, to be available to all new workbooks?

Anonymous
2024-04-01T16:06:03+00:00

When I click More from Format as Table, I want to see my custom table styles listed as "Custom" for all new sheets and workbooks.

Is there a way to rename "Custom" from the More choice from Format as Table?

Thank you,

GJS

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2024-04-01T16:48:56+00:00

    Hi GwenJJS,

    Thank you for reaching out to this forum. I'm Utkarsh and as a fellow Microsoft user, I'm here and ready to help you today. I am a user like you, this is a user forum and not Microsoft directly.

    Do not worry, I will help you sort this issue, rest assured that I will do my best to assist you.

    Sure, here are the steps to add a custom Excel table style to the default styles and rename it:

    1. Create a new blank workbook.
    2. Copy and paste a table with the custom style applied into the new workbook.
    3. Inside the Table Styles menu, right-click and set the custom style as the default style.
    4. Save the workbook to a known location as an Excel template with the name "book" and the extension "xlxt".
    5. In Excel, navigate to Options in the File menu. Then visit the Advanced area, and, under General, near the bottom, you'll see an option for startup files, with a box to specify a path. Paste the path to your templates directory here.

    To rename a custom table style:

    1. Go to the “Design” tab, right-click on the custom style in the Table Styles gallery, and select “Modify Table Style”.
    2. In the Modify Table Style dialog box, edit the name and click “OK” to save the changes.

    You can refer to the link below for detailed information.

    How to set a default custom table style (video) | Exceljet. https://exceljet.net/videos/how-to-set-a-default-custom-table-style.

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    I hope this information helps! If I can be of help with anything else, please let me know. I will be glad to answer any other questions that you might have.

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    Warm Regards, Utkarsh

    4 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-12T13:39:14+00:00

    In the following step ...

    1. Save the workbook to a known location as an Excel template with the name "book" and the extension "xlxt".

    ...is the extension supposed to be .xltx ?

    0 comments
  2. Anonymous
    2024-04-02T14:52:22+00:00

    Hi Gwen,

    It seems like Excel is trying to open Word templates, which is causing the error. Here are a few suggestions that might help:

    1. Separate Templates: Consider storing your Excel and Word templates in separate folders. This can prevent Excel from trying to open Word templates.
    2. Check Disabled Files: If Excel or Word had issues opening a file previously, it might have added the file to its list of disabled files. You can check this list and remove any files that shouldn't be there. Here's how:
    • In Excel or Word, click the File tab.
    • Click Options > Trust Center > Trust Center Settings.
    • On the left, select Disabled Items. If you see any files that shouldn't be there, select them and click `Enable'.
    1. Block External Content: If Excel is trying to access external content (like a Word template), you can block this. Here's how:
    • In Excel, click the File tab.
    • Click Options > Trust Center > Trust Center Settings.
    • On the left, select External Content. You can adjust the settings here to block unwanted external content.
    1. Prevent Auto-Open: Some settings in your operating system might cause Office apps to re-open documents that were open when the app was last closed. You can change these settings to prevent this.

    Remember to always back up your files before making any changes. If the problem persists, consider reaching out to Microsoft Support for further assistance. I hope this helps!

    Regards,

    Utkarsh

    0 comments
  3. Anonymous
    2024-04-01T18:41:00+00:00

    Thank you, Utkarsh, for your prompt reply.

    Your suggestion worked. However, when I open Excel, all of my custom Word templates, which are stored in the same Custom Office Templates folder, try to open. I get errors that say the Word templates are invalid. (Of course, Word documents cannot be opened in Excel.)

    When I open Word, the new Excel template does not try to open; it only opens on the reverse.

    Any suggestions?

    Thank you again,

    Gwen J Skinner

    0 comments