Chat with us, powered by LiveChat

Excel Format as a Table

How to Apply Table Styles in Excel

Besides applying table styles, you can format individual table style elements.

Table Style Options

  1. Click any cell in the table.
  2. Click the Design tab.

    The formatting options available in the Table Style Options group include:

    • Header Row: Toggles the table’s header row on and off.
    • Total Row: Adds a total row to the bottom of the table. This option doesn’t just change formatting, but also allows you to calculate values in the total row.
    • First/Last Column: Displays special formatting for the first or last columns in the table.
    • Banded Rows/Columns: Displays odd and even rows and columns differently for easier readability.
  3. Select the option(s) you want to apply in the Table Style Options group.
    Table Styles

FREE Quick Reference

Click to Download