Formatting Tables

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

Formatting tables

Video: Formatting Tables in Excel 2010

Launch video!Watch the video (2:37).

Just like regular formatting, tables can help to organize your content and make it easier for you locate the information you need. To use tables effectively, you'll need to know how to format information as a table, modify tables, and apply table styles.

Optional: You can download this example for extra practice.

To format information as a table:

  1. Select the cells you want to format as a table. In this example, an invoice, we'll format the cells containing the column headers and order details.
    Selecting cells to format as a tableSelecting cells to format as a table
  2. Click the Format as Table command in the Styles group on the Home tab.
    Format as Table commandFormat as Table command
  3. A list of predefined table styles will appear. Click a table style to select it.
    Selecting a table styleSelecting a table style
  4. A dialog box will appear, confirming the range of cells you have selected for your table. The cells will appear selected in the spreadsheet, and the range will appear in the dialog box.
  5. If necessary, change the range by selecting a new range of cells directly on your spreadsheet.
  6. If your table has headers, check the box next to My table has headers.
    Creating a tableCreating a table
  7. Click OK. The data will be formatted as a table in the style you chose.
    Data formatted as a tableData formatted as a table

Tables include filtering by default. You can filter your data at any time using the drop-down arrows in the header. To learn more, review our Filtering Data lesson.

To convert a table back into normal cells, click the Convert to Range command in the Tools group. The filters and Design tab will then disappear, but the cells will retain their data and formatting.