Table Styles · Full edition

The table style editor PowerPoint never had

Design table styles for Word, PowerPoint and Excel in one place: fill color, borders, font, alignment and cell padding, per header row, total row, column, banded row or banded column. Export a style as a .ksstyle file and use that same style, without retyping anything, in all three programs.

01

One editor for Word, PowerPoint and Excel

The Table Branding Manager is inspired by the table style editor in Word, but is more robust, more intuitive, and works for Word, PowerPoint and Excel.

Fill color, borders, font, alignment and cell padding are set per part: the whole table, header row, total row, first or last column, banded rows and banded columns. Choose the part on the left, and see a live preview of the result on the right.
In that preview you can use checkboxes to indicate what you want to see: header row, total row, first and last column, banded rows and columns, just like a table in one of the applications, but now in the editor.

Word has its own table style editor, but it isn't intuitive, and sometimes certain settings simply can't be changed. Excel has its own table style editor too, but it doesn't let you set alignment.

With the Table Branding Manager you design a style once and import it into all three programs.

After using Table Branding Manager: same branded table style in Word, PowerPoint and Excel
02

Design table styles for Excel too

Excel table styles are designed directly in the Full edition, the same way as for Word and PowerPoint: design, check the live preview and adjust, all in one place.

You can also set horizontal and vertical text alignment in a table style, including for Excel. Excel's own table style options don't let you configure that at all, even though the file format supports it. Word and Excel support alignment in a table style, PowerPoint doesn't. You'll see a warning there.

Fill color Alignment Font

Part

Header row ▾

Horizontal

Center ▾

Vertical

Center ▾
03

The .ksstyle file: the connection between the three programs

For Word, PowerPoint and Excel every function is available: adding, duplicating, editing, renaming or deleting a style, setting it as the default style, or adjusting the colors.

The connection between the three is the .ksstyle file: export a style to it, then import it into a Word, PowerPoint or Excel template or file. The three programs store table styles differently and don't all support the same properties. If a program can't store a property, you'll see a warning there instead of the property being silently dropped.

That way you design a table's formatting once, instead of rebuilding it by hand three times.

Export

Style

Annual report header ▾

Save as

annual-report-header.ksstyle
Word PowerPoint Excel
04

Also works directly on documents that already exist

Changing a table style in a template usually doesn't work retroactively: Word doesn't automatically update the tables in documents that were already created from that template by default. That's why this tool doesn't just open and edit templates (.potx, .dotx, .xltx), but also regular documents, presentations and workbooks directly.

So an outdated table in an existing document doesn't need to be rebuilt by hand. You simply update it, just like in the template.

Want to roll this out to colleagues who shouldn't need to design anything? The Import-only edition imports a .ksstyle file you created into existing documents, without anyone being able to accidentally change a style.

05

Replace every color, in seconds

Duplicate an existing style and open Replace color: you'll see, in one overview, every color the style uses, in fill color, borders and font alike, across every part (header row, total row, first column, banded rows...). Colors that recur in multiple places are automatically deduplicated to a single row.

Choose the replacement per color and everything is updated at once, as a single step in the undo history. That way you turn “red” into “blue” in seconds, without going through the header row, total row, first column and banded rows one by one.

Replace color

Colors in use

Header row · fill color
Banded rows · border
Banded rows · fill color
06

One style library, not just one file

Open a folder of .ksstyle files directly as a style library. One per client or project, for example, so the styles of different clients stay separate.

It's also the way to go if you design styles for more than one Office program. Working from the library instead of an open file means you're never limited by what one specific file format can store: Save style to library always keeps a style's full design.

The one thing a library can't provide on its own is colors and fonts. Load those by opening a .thmx file, or by combining the Color and Font XML files you saved from the Design tab in one of the Office programs.

Style library

Folder

Brand styles ▾

Preview against theme

company.thmx

Within the technical boundaries

Honest about the limits

Word, PowerPoint and Excel each store a table style in their own way, and their capabilities differ from one another. Every property can be edited regardless of which file is open. When the open file can't store a property, you'll see a warning and the option stays visible. And table styles support exotic properties that I don't encounter in practice.

No gradient or pattern fills. In the table style galleries, for example, you can create a gradient in a border. Many border styles are supported too, of which I only encounter a small fraction in practice. I try to keep the tool as intuitive as possible, and deliberately leave some options out.

Font size and underline can be set, but PowerPoint can't store them in a table style. There, that belongs to the template itself, a choice made by PowerPoint, not by this tool. So you'll see a warning there.

Cell padding can be set, but only Word stores it in a table style. PowerPoint and Excel show a warning there.

Alignment can be set, but PowerPoint can't store it in a table style. Word and Excel can. For Excel that's a genuine addition, since Excel's own table style options don't offer alignment at all.

The Table Branding Manager supports the options actually used in professional templates in practice. Whatever is already in a style but isn't supported by this editor is preserved as is.
I'm always open to feature requests. If I've overlooked an important style property, I'll try to add support for it.

Who is the Full edition for?

I use the Table Branding Manager myself, to support table styles with minimal effort in the templates I've been building since 2005. On top of that, the Full edition is directly useful to two other groups.

Are you a template builder yourself?

Then this is the tool that lets you do the same for your own templates: design a table style and carry it over into Word, PowerPoint and Excel without retyping anything.

Does your company manage its own templates?

Then whoever manages the templates designs or updates the table styles with the Full edition. Want to roll those styles out to colleagues who don't need to design anything themselves? That's what the Import-only edition is for.