Make eye-catching tables quickly in Excel

If you spend a lot of time creating and manually formatting new tables in Excel, there’s a better way. Simply select the range of cells that you want to include in your table and click the Format as Table button:

Format as Table

You’ll be prompted to confirm your cell range:

Format as Table cell range

And then you can go in and customize the headers (just click in the cells and type) and begin entering your data and formulas:

Table sample

If you want to customize, select New Table Style and make your own:

New Table Quick Style

This feature works in both Excel 2007 and Excel 2010.


Comments (1)

  1. ankit5 says:

    Thanks, but these are hardly eye catching tables. I'm looking for something fancy!