Excel® 2013 On Demand

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

Click the Home tab.

Click the Format as Table button.

Do any of ...