Creating or Modifying a Table Style

Excel Table Quick Styles give any worksheet a professional look, but you may need to modify a Quick Style to better suit the needs of a particular project. For example, the Quick Style you applied might be perfect except that the font or color used should be different—to match the rest of your report. You can modify an existing Table Quick Style or create a new one from scratch. When you create or modify a Table Quick Style, you have the option to set the table style as the default when you create a new table.

Create or Modify a Table Style

Image Click the Home tab.

Click the Format as Table button.

Do any of ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.