Microsoft Excel 2010 Format Tutorial

Basic Excel 2007 / 2010 Format Tutorial Overview

Related Tutorial: Excel IF Function Format Tutorial

This tutorial forms part 2 of how to create and format a basic spreadsheet in Excel 2007 / 2010.

Part 1 of the tutorial covered entering the tutorial data and using formulas and functions in Excel.

This part of the tutorial covers how to format the worksheet, and copying formulas using the fill handle.

By following the steps in the tutorial topics below you will create a worksheet that will match the image above.

Tutorial Topics

• Entering Tutorial Data


• Change Column Widths


• Merge and Center the Worksheet Title


• Changing Data Alignment


• Adding Number Formatting


• Adding Row Shading Using Formatting Styles


• Shading Alternate Rows Using Conditional Formatting


• Copying Formulas and Formatting with the Fill Handle

• Excel 2007 / 2010 Step by Step Format Tutorial
• Entering Tutorial Data
• Change Column Widths in Excel
• Merge and Center Cells
• Align Worksheet Data
• Adding Number Formatting
• Adding Row Shading Using Formatting Styles
• Excel Alternate Row Shading
• Copying Formulas and Formatting with the Fill Handle