Help & Support
Send Feedback
Table Styles
Apply a uniform style to your tables in one click; add your own custom style templates
1,612,691 users
Works with
Install
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 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.

Version 1.1:
We added more default styles, try them out!

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

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/
Reviews
A User of Table Styles
July 2, 2019
This is the absolute worst table styles and does NOT work as advertised. STAY AWAY & DO NOT USE! Microsoft Excel > Google Sheets
Submit reply
Cancel
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
Submit reply
Cancel
A user of Table Styles
September 3, 2018
Thank you very much for your feedback, Dakota! We will consider implementing this functionality into the next version of the product.
Ben Wagner
June 1, 2018
It's the best extension/add-on out there that does what it does 🤷‍♂️
Submit reply
Cancel
A User of Table Styles
December 30, 2017
Very easy to use and does exactly what I need it to do. Create a table.
Submit reply
Cancel
A User of Table Styles
March 23, 2017
Wow, I was thrown but the warn every time I saved a custom style because I didn't understand. There was nothing I did wrong, it's only there for a warning the certain style elements cannot be saved. You can save styles and use them for ANY old or new sheets!
Submit reply
Cancel
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
Submit reply
Cancel
A user of Table Styles
October 12, 2017
I do not think the authors "need to fix" anything. The add-on was provided for free. They are not forcing anybody to use it. Maybe the authors could be asked politely to fix that issue, or you could write a better solution and possibly make it open source if you are so inclined.
A User of Table Styles
December 26, 2015
Works as expected, which is great, but not so fast)) I would like to check, is it secure to my data on a spreadsheet? Can this add on share my private data?
Submit reply
Cancel
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)
Submit reply
Cancel
Felicia Cockrell Yoakum
August 27, 2015
Recommend adding the autofill formula and format option, similar to Excel when you create a table.
Submit reply
Cancel
A user of Table Styles
April 14, 2016
yeah, I vote for this too. Also an automatic filter on column headers would be great :)
Daniel Whiddon
October 27, 2015
I second this notion.
A User of Table Styles
July 14, 2015
Best option available, this should be default. Very helpful customer service.
Submit reply
Cancel
1-10 of 20
Additional information
Search
Clear search
Close search
Google apps
Main menu