Whenever I look at the default Table Style that Excel spits out:
…I think: Nice structure. Pity about the finish. That formatting is a bit eyestrain-inducing , if not migraine-producing. I’m going to have to sand that sucker back to the wood, and repaint it.
…but there are very few that are Few-worthy, let alone sponge-worthy. This one is getting close:
…but that huge contrast in the header row between pitch-black fill and white writing is really Tufte on my eyes, not to mention that dark grid makes this data look like it comes from Excel. Stephen won’t like that at all.
So I create my own style:
Ahh, that’s better…it lets the data – and our eyes – breathe a little easier. It uses pretty minimal formatting so that the data is front-and-centre, rather than the table itself.
What the? Why am I NOT in that list? And why doesn’t that list have my beautifew new Custom Table Style applied to it? Ah well, can’t be good at Excel and lucky in lust, I guess. And anyways, at least I saved that Custom Table Style to the Table Styles gallery earlier. Let’s just apply my style manually from there:
That’s right, Wayne. No Stairway. Denied, indeed.
What? Really? You went to all the effort to allow users to create new Table Styles, but you didn’t give them a way to reuse those anywhere else?
It turns out, the only way we can make our beautifew new Custom Table Style permanently stick around is by:
- Copying a Table that uses our new Table Style into a new blank workbbook
- Setting that Table Style as the Default Table Stlye, like I did earlier
- Deleting that Table
- Saving the workbook as an Excel Template in the Startup folder, so that Excel will use this workbook – and our beautifew new Custom Table Style – as a template whenever we create a new document.
Well that is just…
You can then copy that path, so that later on you can paste it into the Save As dialog box.
- You want to change the name of the workbook from Book1 to just Book. (Excel will add the 1 or 2 or whatever automatically when it opens a copy of the template)
- You might as well go all-out and save it as an Excel Macro Enabled Template, so that you never again get this pesky message:
- You want to paste that Startup folder location in after you’ve selected that Excel Macro Enabled Template option from the Save as type dropdown, not before. Why? Because otherwise Excel inexplicably overwrites your previous directory choice as soon as you choose to save a file as a Template with this location: