Table Styles for Google Sheets

Make your tables in Google Sheets look professional

This add-on will help you visually organize data in your sheets. It comes with a set of style templates that you can use for your tables straight away, also living you the option of creating custom formatting for Google Sheets. Make your tables stand out with a unique combination of table elements and their style that you can edit any time.

Get it for free
Table Styles for Google Sheets

With Table Styles you will

  • Apply table style to selection Select a range and quickly convert it to a formatted table.
  • Personalize all table elements Customize anything from basic formatting like font to borders and background color.
  • Create style from selection Create your own styles and use them in any sheet.
  • Manage formatting styles Edit color schemes you created or delete obsolete custom templates from the list.

How to style your table in Google Sheets

   
Video: How to design your table with our add-on
Choose and apply an existing color scheme…
Choose and apply an existing color scheme…
…or create your own formatting style
…or create your own formatting style
Customize each table element to your liking
Customize each table element to your liking
You will find the pattern you created in the list of custom styles
You will find the pattern you created in the list of custom styles
Edit or delete old styles in a click
Edit or delete old styles in a click
Video: How to design your table with our add-on
Choose and apply an existing color scheme…
…or create your own formatting style
Customize each table element to your liking
You will find the pattern you created in the list of custom styles
Edit or delete old styles in a click

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Volume discounts: the more you buy, the less you pay
Free support

These companies choose Ablebits products

   

Frequently asked questions

About Table Styles for Google Sheets

  • What is Table Styles and what do I need it for?

    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.

  • Why should I use your add-on when there are formatting tools in Google Sheets?

    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.

  • How to create a table style in Google Sheets?
    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.

  • How to apply style to the table in Google Sheets?
    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.

  • Can I create a completely new pattern without pre-formatting any table in advance?

    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.

  • Can I modify some parts of my styles later?

    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.

  • Can I tweak the number of header rows or right columns to format?

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

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)
Get it for free

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close