Skip to main content

Introducing How to Add Custom Table Styles in Excel

· 3 min read

Once you discover Excel's ListObject (table styles), it's so convenient you'll want to use it for even small tables.
However, one downside is that the default table styles (appearance) are not very appealing.

img

From left to right:

  1. None: No style applied
  2. Standard: Default table style
  3. TableStyleLightBlue: Custom table style #1
  4. TableStyleLightGreen: Custom table style #2

You can create your own custom table styles like the ones above, but the issue is that they are saved on a per-workbook basis.
While you can copy them to other workbooks, you may end up transferring unwanted data, which can be risky.

That’s where a script that lets you add table styles anytime comes in handy.
If you have such a script, you can apply your preferred table style to any workbook whenever you like—so let me show you how.