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

Written by Upendra Kumar
Saturday, 07 July 2007 Category MS Excel 2007 - Formatting.

General Information



Formatting cells Conditional Formatting Formatting sheets for printing



In this tutorial, you will apply formatting options to cells and prepare the sheet for printing.

Formatting cells

1) Open the Table Usage 2007.xlsx Sample.


Illustration 1: Table usage sample excel file. Click here to view larger image.

2) Select the titles rows. Use the *Horizontal Alignment* group to center the titles.


Illustration 2: Horizontal center alignement.

3) Select the titles rows. Use the *Verical Alignment* group to center the titles.


Illustration 3: Select the range.

4) Select all cells containing numbers. Right click and select the *Format cell* menu item.


Illustration 4: Blank Pivot table layout.

5) Configure all formatting options and press the Ok button.


Illustration 5: Formatting options.

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