Basic Excel 2003 Spreadsheet Tutorial

Excel 2003 Formatting - Changing Data Alignment

Basic Excel 2003 Spreadsheet Tutorial

© Ted French

Excel 2003 Formatting - Changing Data Alignment

Note: For help on these steps, refer to the image above.

This step involves using icons located on the Formatting toolbar, which is normally located at the top of the Excel 2003 screen. If it is not present, this article, Finding Excel Toolbars can help you locate it.

1. Drag select cells A2 - D2.
   
   
2. Click on the Merge and Center icon on the Formatting Toolbar to center the title.
   
   
3. Drag select cells B4 - B6.
   
   
4. Click on the Align text right option icon on the Formatting Toolbar to right align the data in these cells.
   
   
5. Drag select cells A9 - A12.
   
   
6. Click on the Align text right icon on the Formatting Toolbar to right align the data in these cells.
   
   
7. Drag select cells A8 - D8.
   
   
8. Click on the Center icon on the Formatting Toolbar to center the data in these cells.
   
   
9. Drag select cells C4 - C6.
   
   
10. Click on the Center icon on the Formatting Toolbar to center the data in these cells.
    
    
11. Drag select cells B9 - D12.
    
    
12. Click on the Center icon on the Formatting Toolbar to center the data in these cells.

Return to Index page

• Excel 2003 Step by Step Tutorial
• Entering Data into Excel 2003
• Widening Columns in Excel 2003
• Adding the Date and a Range Name
• Adding Formulas in Excel 2003
• Excel 2003 Formatting - Changing Data Alignment
• Excel 2003 Formatting - Number Formatting
• Excel 2003 Formatting - Changing cell background color
• Excel 2003 Formatting - Changing Font Color