MS Tips and Tricks | Microsoft Excel 2007 | Formatting cells and sheets {Tutorial for beginners}

Affiliates

Amazon.com

Popular Microsoft Excel Books

Excel 2003 Bible

Author: John Walkenbach

Excel 2003 for Dummies

Author: Greg, PhD Harvey

Microsoft Office Excel 2003 Step by Step

Author: Curtis Frye

Excel VBA Programming For Dummies

Author: John Walkenbach

Excel 2003 Personal Trainer

Author: Inc

Microsoft Office Excel 2003 Inside Out

Author: Craig Stinson

Excel 2003 All-in-One Desk Reference for Dummies

Author: Greg Harvey

Popular MS Excel Related Websites

Microsoft Excel 2007 Tutorial for beginners

Welcome to MS Tips and Tricks

Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

Microsoft Excel Tips and Tricks for beginners

6) Continue formatting the cells until you're satisfied.

Illustration 6: Drag and drop fields. Click here to view larger image.

7) Another way to quickly format a data table is to apply a table format. Select the Format as Table command from the Styles Group .

Illustration 7: Formatting as table.

8) A style's list will be displayed. Pick up the desired layout.

Illustration 8: Table Layouts.

9) A dialog box will appears with the table range selected. Press the Ok Button.

Illustration 9: Table Range.

10) As you cann see, the new layout is applied. Also, a Data filter appears in each column title botton corner.

Illustration 10: Automatic format. Click here to view larger image.

Advertisement

Your Ad Here

Copyright © MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster