Formatting Tables

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


  1. Open an existing Excel 2010 workbook. If you want, you can use this example.
  2. Format a range of cells as a table. If you are using the example, format the column headers (Quantity, Description, etc.) and the order details.
  3. Add a row or a column.
  4. Change the table style options. If you are using the example, add a total row.
  5. Change the table style several times. Take note of how the table options may appear different depending on the style you use.