Excel® 2013 On Demand

Formatting a Table

Formatting worksheet table data can be quick and easy with Table Quick Styles. To make formatting data more efficient, Excel has a gallery of table styles based on the current theme. A table style includes preset combinations of fill colors and patterns, font attributes, borders, and font colors that are professionally designed to enhance your worksheets. You can apply a Table Quick Style using the Home (Format as Table button) or Design tab (Quick Styles button (New!)) under Table Tools.

Apply a Quick Style to a Table

Select a cell or range in the table to which you want to apply a Quick Style.

Do any of the following: