App Icon
Apply a uniform style to your tables in one click; add your own custom style templates.
Works with:
2,609,333
Overview
Table Styles add-on lets you quickly apply a professional and uniform look to your tables in Google Sheets. 
You can 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.

If your company uses custom colors, select an existing table and add its style to your collection. You can also create your formatting template from scratch and use it in any spreadsheet: add borders, change font and background color in any table part like header or first-row stripe.
 
Besides 24 pre-supplied styles, the current version keeps three of the most recent styles you create active. 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.

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:

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
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
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:
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 31
Search
Clear search
Close search
Google apps
Main menu