by Natalia Sharashova, updated on
Table Styles has been a part of our Google Sheets arsenal for a long time. The time has come: the time for a major upgrade :) Version 2.0 brings a fresh simplified design (way better and user-friendlier looks) and opens up new possibilities to format your Google tables.
Tip. Install Table Styles from the Google store to try everything out.
The first thing that will catch your eye — lots of new style patterns! We designed multiple new style sets featuring various shades and colors. Some of them may even remind your favorite movie or a video game ;)
All in all, you have 52 built-in styles ready to be used as is, tailored to your needs and saved as your custom sets.
All patterns are grouped into 6 types based on their color themes: practical, monochrome, light, juicy, contrasting and even dark.
We believe even the most demanding Google Sheets users will find something to their liking. Go ahead and prove us wrong ;)
You can finally format borders:
There's also an addition to the horizontal alignment: the automatic type.
Use it and the values in your Google table will be automatically aligned based on their format just as they normally do in spreadsheets, e.g. numbers to the right and text to the left.
However neat the whole style is, you probably don't always want to apply it to your entire table.
The new version makes it possible to style only particular table element(s) from the chosen style set: font, its size/formatting/color, fill colors, borders, horizontal/vertical alignment, and text wrapping.
We redesigned the add-on completely! It now keeps up with the updated Google Sheets design. But what's more important — you get access to any setting from just one window — without any extra steps. Enjoy! :)
We get it — some parts of your table may share formatting, for instance, the font color in the left and right columns. And we agree — applying the same formatting to each part is unreasonable.
That's why you need the 2.0 version. It lets you select all necessary elements and format them all at once. Awesome!
The updated add-on has more fancy, simple and funny fonts so you could personalize your styles. Let us know if there are still some you're missing ;)
Table of contents