To create a new style, pop pop the table styles menu and select New style from the bottom.
I’ll name this new style “simple”.
Custom styles appear in the upper left of the Table styles menu.
Excel will display the name when you hover over the thumbnail.
However, notice that new styles are not applied when created.
I need to apply the new style to my table as a second step.
Once applied, the new style will be highlighted in the list.
To edit the style, right-click and select Modify.
Formatting for the whole table2.
Formatting for the first, second, and last row and column3.
Formatting for the header row, and4.
Notice Whole Table now appears in bold, which indicates formatting had been defined.
The mini preview window also shows the border now.
When I click OK, the border is applied.
I’ll repeat the process and add a fill to the header row.
Notice Header now also appears in bold.
And when I click OK, the header is formatted.
Finally, I’ll add formatting for row banding.
Here, I want to use “First row stripe”.
When I click OK, the banding is applied.
So that’s how to create a new style from scratch.
To customize an existing style, follow this process:
1.
First duplicate the style and give it a name2.
Second, apply the style to your table3.
As before, the custom style will appear in the upper left of the Table Styles menu.
