Add and format tables and charts

Apply a table style

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Tip: Video not in your language? Try selecting Closed Captioning Closed captioning button .

Give your tables a designer’s touch with table styles. Choose from a selection of color schemes, apply alternate row colors, add a heading row, or format a total row.

Apply a table style to an existing table

  1. Select any cell in the table.

  2. Select Design.

  3. In the Table Styles gallery, select the table style you want to apply.

    Note: To remove a table style, select Design. In the Table Styles gallery, select More, and then select Clear or Clear Table.

Change the table style options

To change the design of the table, do one or more of the following:

  • To add special formatting to the first row in a table, select Design > Header Row.

  • To add special formatting to the last row in a table, select Design > Total Row.

  • To alternate row or column colors and make tables easier to read, select Design > Banded Rows or Design > Banded Columns.

Repeat a table heading on subsequent pages in Word or Outlook

  1. Select the heading row or rows that you want to repeat on each page.

  2. Select Layout > Repeat Header Rows.

Want more?

Change the look of a table

Word training

PowerPoint training

Excel training

Outlook training

To add flair to your tables in Office select the table and select the Design tab.

If your table has a header row, to apply a specific style to it, select the check box.

In Excel, you can also add filters to the header row.

To add a totals row at the bottom of a table with numerical data, select Total Row.

To make the first and last columns stand out with special formatting, select First Column and Last Column.

To make rows stand out, select Banded Rows.

To make columns stand out, select Banded Columns.

To change the look of the entire table, you can preview a specific style by pausing over it and to apply a style, select it. You get different style selections based on the Table Style options you choose.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×