Format an MS Excel Table Quickly in Version 2007

• by Carol Bratt on 20081113 @ 09:52PM EST | google it | send to friends
• Filed under Carol's Corner Office | (related terms: format, headers)

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 CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

Free eBook: Windows 7: Tips & Tricks. This eBook is for users that want to go one step further in their understanding of the Windows 7 operating system. With over 50 of the finest tips and tricks, this 113 page Windows 7 eBook features a plethora of screenshots, and was written especially for novices in mind. Also included is a bonus section for Windows 7 applications. Written and presented by technology enthusiast Vasu Jain. About the author: Vasu Jain is a software developer, web engineer, blogger, and Master's student at University of Southern California. He has written 2 other eBooks, including Office 2010 Tips & Tricks, and Developing apps for Windows 8. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.