The Excel Table Styles give a user a choice of different styles ranging from Light, Medium and Dark.

There are over 50 choices depending on your favorite style or company standard but you are not only limited to those.

You have extra Table styles in the Page Layout tab in your Ribbon menu.  Click on that and select the Colors drop-down and you can choose from an array of combinations.

Go crazy with this to brighten up your dull data 🙂

YouTube video

Extra Excel Table Styles | MyExcelOnline

DOWNLOAD WORKBOOK

STEP 1:  Select anywhere in the table. Go to Table Tools > Design > Table Styles

Extra Excel Table Styles | MyExcelOnline

There are a lot of styles to choose from! Pick any that you prefer.

Extra Excel Table Styles | MyExcelOnline

STEP 2:  Now here is the magic trick, if you need more colors, there’s more!

Go to Page Layout > Colors and there are even more combinations!

Extra Excel Table Styles | MyExcelOnline

After picking one, here is the final result for the Excel Table Style!

Extra Excel Table Styles | MyExcelOnline

 

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin