App Icon
Make your tables look professional with 50+ ready-made styles or create your own style templates.
Listing updated:February 8, 2022
Works with:
3,458,256
Overview
Table Styles add-on lets you quickly apply a professional and uniform look to your tables in Google Sheets.

50+ PREDEFINED STYLES IN 6 GROUPS
    1. practical
    2. monochrome
    3. light
    4. dark
    5. juicy
    6. contrasting

Just select your data and use one of the predefined styles that come with the add-on. The templates are very flexible in use as they let you apply format only of those table elements that you check off.

CUSTOMIZE EXISTING & CREATE NEW STYLES

You can edit all pre-supplied styles and save them as new templates.

Or create your formatting pattern from scratch and use it in any spreadsheet: add borders and customize their appearance, change font and background color in any table part like header or alternating rows stripe.
 
At the same time, the add-on gives you the possibility to edit or delete all your custom templates to keep them up-to-date.

APPLY WHOLE STYLE OR ONLY ITS PARTS

You can apply only parts of the style to your table. Select those you'd like to put on: 
    * font, its size, color &/or formatting
    * fill color
    * borders, their style & color
    * horizontal/vertical alignment
    * text wrapping

30 DAYS OF FREE USE

Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about adding or applying table styles, please post them here:
https://www.ablebits.com/docs/google-sheets-apply-table-styles/
We'll be happy to assist!

Table Styles is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
––––––––––
WHAT'S NEW

***** V2.0 (14 December 2021)*****
★ New features ★
- Meet the new version! With 52 various style templates grouped into 6 main types.
- You can finally format border colors & styles and apply automatic horizontal alignment (based on the data type) to all cells.
- Apply only parts of the style to your table. Select and format all, some, or one of the following: font, its size/formatting/colors, fill colors, borders, horizontal/vertical alignment, text wrapping.
- We introduced yearly & lifetime plans. You can still enjoy a fully functional trial version of the add-on for 30 days.

Improved:
- Enjoy the new design! Everything you need is stored in a single pane now. Visit the help page for more details.
- Editing multiple table elements is finally possible. Select all necessary elements like header row + left column to edit and apply the same style to all these selected parts at once.
- More fonts are available for you to use in your styles.
Fixed:
- Didn't adjust alternating colors if you added/deleted rows inside your formatted table.

***** Version 1.5 ***** 
See bold, italics, and alignment formatting of your styles in the preview.

***** Version 1.1 ***** 
We added more default styles, try them out!
Additional information
PricingPaid with a free trial
Developer
Trader status unspecified
Privacy policy
Terms of service
Table Styles will ask for the permissions shown below. Learn more
Table Styles will need access to your Google account
This will allow Table Styles to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
View and manage data associated with the application
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of Table Styles
March 2, 2015
For those having problems applying the format, you may need to close the ad at the bottom so you can see the "Apply" button. It works, but as mentioned previously, the formatting moves with the cell (unlike Excel). This means if you sort your data, you will need to reapply the formatting.
Is this review helpful?
Yes
No
Profile Picture
A User of Table Styles
April 8, 2015
Easy install, works like a charm! Now my rows and headers are easily identifiable, easily readable. Great add-on!!
Is this review helpful?
Yes
No
Profile Picture
A User of Table Styles
August 10, 2014
Unfortunately this doesn't work at all. I select my cells, click "apply to selection" and it does nothing. Hopefully you guys get it going though, because the concept is exactly what I was looking for.
Is this review helpful?
Yes
No
Profile Picture
A User of Table Styles
July 28, 2016
Overall this addon is very good except you need to fix insert and delete row issue. Whenever I add new row it doesnt work
Is this review helpful?
Yes
No
Profile Picture
A User of Table Styles
November 3, 2015
Love it - works exactly as advertised. Several notes: 1) The Options dropdown (under style selector) gives more control 2) Below style selection is the "Apply to Selection" button. You might need to close the ad to see this button 3) You have to re-apply the formatting if you modify the table (e.g. insert a row)
Is this review helpful?
Yes
No
Profile Picture
A User of Table Styles
January 6, 2015
It's ok but it only formats superficially: - If you re-arrange the values of your table, guess what happens to your formatting! It all goes weird instead of keeping the formatting in place and only moving the values. - Same happens when you add/remove a line or column. Then you need to format the entire thing again. - If you select everything including the last column and there are no more columns on the right, the tool bug and has the "working" forever. It simply crashes there. So I dno't even bother waiting. I simply X it off and re-open the tool.
Is this review helpful?
Yes
No
Profile Picture
A User of Table Styles
December 30, 2017
Very easy to use and does exactly what I need it to do. Create a table.
Is this review helpful?
Yes
No
Profile Picture
Ben Wagner
June 1, 2018
It's the best extension/add-on out there that does what it does 🤷‍♂️
Is this review helpful?
Yes
No
Profile Picture
Dakota Taylor
August 30, 2018
NEEDS to be able to drag and drop formatting and being able to add table rows or columns with more ease other than copy paste. BUT I Love the styles and how it walks you through the table stuff. And if i'm just missing it i'm sorry ahhaa
Is this review helpful?
Yes
No
Profile Picture
A User of Table Styles
August 5, 2014
Completely does not work. I get a spinning "working" symbol and after waiting 20 seconds nothing is formatted.
Is this review helpful?
Yes
No
1-10 of 35
Search
Clear search
Close search
Google apps
Main menu