Format an MS Excel Table Quickly in Version 2007

Dennis Faas's picture

You can quickly and easily format lists of data in MS Excel 2007 very quickly and easily using galleries of styles.

Follow the steps below to learn how:

  1. On the Ribbon click on the Home tab.
  2. There you will find the Format as Table Command.
  3. Check My table has headers in the dialog box (if you have headers).

This will allow you to quickly sort or filter columns within your spreadsheet using the header's integrated drop-down menus.

It doesn't get much easier than that does it?

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet