Excel Table Style

Table Style

Excel has many ready to use styles which can be applied for tables.

Table styles is to change the appearance of the table.

It can be changed to:

• Make it easier to read and understand
• Make it look better

The table style is Blue, Table Style Medium 2 by default.

Example: Blue, Table Style Medium 2, which is how the default looks like.

Excel has three main categories for Table styles:

• Light; Light colors, more white space
• Medium; Medium colors, medium white space
• Dark; Dark colors, less white space

The table style can be applied in a few steps.

Example - Applying Light Style

Type or copy the values to follow along:

Example

    Name	Type 1	Type 2	HP	Attack	Defense
    Abra	Psychic		25	20	15
    Kadabra	Psychic		40	35	30
    Alakazam	Psychic		55	50	45
    Machop	Fighting		70	80	50
    Machoke	Fighting		80	100	70
    Machamp	Fighting		90	130	80
    Bellsprout	Grass	Poison	50	75	35
    Weepinbell	Grass	Poison	65	90	50
    Victreebel	Grass	Poison	80	105	65
    Tentacool	Water	Poison	40	40	35
    Tentacruel	Water	Poison	80	70	65
    Geodude	Rock	Ground	40	80	100
    Graveler	Rock	Ground	55	95	115
    Golem	Rock	Ground	80	120	130
    Ponyta	Fire		50	85	55

Convert the range into a table.

• Select a cell in the table range

• Click the Design Table tab ()

• Click on the Table Styles option button

Note: The Table Style that is already applied has a green rectangle around it. In this case Blue, Table Style Medium 2.

Clicking the Table Style option button opens a menu with different style options.

Here the three categories are presented; Light, Medium and Dark.

• Click on the Light, Green, Table Style Light 21. Found in the Light category.

Well done! The formatting of the table has changed to the light green style.

Apply Gray, Table Style Dark 4. Found in the Dark category.

Did you make it?

Note: Get familiar with the Table Styles. Try different options to see how they look.