Make eye-catching tables quickly in Excel

Make eye-catching tables quickly in Excel

  • Comments 1
  • Likes

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.

Suzanne

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

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment