Table Styles for Google Sheets

With this tool at hand, changing the appearance of your data in Google Sheets is very simple. You can apply any of pre-supplied styles to the entire table, or even choose what table parts are present in the selection. Besides existing templates, it lets you add your custom formatting patterns to the collection. You can edit or remove an obsolete style at any time.

Standard Google Sheets options let you alter only one element at a time, i.e. change font or background color. Also, you need to select each table part (a row or a column) separately to change it.

With our add-on, you will apply different styles to certain parts of the entire table at once: header, first row stripe, etc.

1. Select the range with the formatted table.
2. Run the add-on under Add-ons > Table Style > Create style from selection.
3. Give your template a name and select necessary table elements.
4. Adjust the formatting for each element if needed.
5. Click Save.

See a more detailed description here.

1. Select the range with your table to format.
2. Go to Add-ons > Table Styles > Apply style to selection.
3. Choose the color scheme you'd like to apply.
4. Adjust its formatting options if necessary.
5. Click to Apply to the selection.

See a more detailed description here.

Sure, you can create it from the very beginning, determining the table parts you have and choosing all fonts, colors, and borders for them. But if you have an exemplary Google Sheet table ready, adding it as a style template would be much faster.

Of course! You can manage existing templates in the same way you create them. Change the formatting of your table header, add borders to your left column, or re-color every other row to make the information easier to read.

Yes, editing settings let you change the number of all elements in your table.