Formatting Tables

Formatting Excel tables can improve how your spreadsheet looks. Use the table function in Excel to also better organize content.

Modifying tables

To add rows or columns:

  1. Select any cell in your table. The Design tab will appear on the Ribbon.
  2. From the Design tab, click the Resize Table command.
    Resize Table commandResize Table command
  3. Directly on your spreadsheet, select the new range of cells you want your table to cover. You must select your original table cells as well.
    Selecting a new range of cellsSelecting a new range of cells
  4. Click OK. The new rows and/or columns will be added to your table.
    After adding new rowsAfter adding new rows

To change the table style:

  1. Select any cell in your table. The Design tab will appear.
  2. Locate the Table Styles group. Click the More drop-down arrow to see all of the table styles.
    The More drop-down arrowThe More drop-down arrow
  3. Hover the mouse over the various styles to see a live preview.
  4. Select the desired style. The table style will appear in your worksheet.
    After changing the table styleAfter changing the table style

To change table style options:

When using an Excel table, you can turn various options on or off to change its appearance. There are six options: Header Row, Total Row, Banded Rows, First Column, Last Column, and Banded Columns.

  1. Select any cell in your table. The Design tab will appear.
  2. From the Design tab, check or uncheck the desired options in the Table Style Options group.
    Table style optionsTable style options

Depending on the table style you're using, certain table style options may have a different effect. You may need to experiment to get the exact look you want.