1. Home
  2. Computing & Technology
  3. Spreadsheets

Basic Excel 2007 Spreadsheet Tutorial

By Ted French, About.com

7 of 9

Excel 2007 Formatting - Changing Data Alignment

Alignment Formatting in Excel 2007

Alignment Formatting in Excel 2007

© Ted French

Excel 2007 Formatting - Changing Data Alignment

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

  1. Drag select cells A2 - D2.

  2. Click on the Home tab.

  3. Click on the Merge and Center option in the Alignment section of the ribbon to center the title.

  4. Drag select cells B4 - B6.

  5. Click on the Align text right option on the ribbon to right align the data in these cells.

  6. Drag select cells A9 - A12.

  7. Click on the Align text right option on the ribbon to right align the data in these cells.

  8. Drag select cells A8 - D8.

  9. Click on the Center option on the ribbon to center the data in these cells.

  10. Drag select cells B9 - D12.

  11. Click on the Center option on the ribbon to center the data in these cells.

Return to Index page

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Spreadsheet Lesson Plans
  5. Excel 2007 Formatting - Formatting Excel 2007 Spreadsheets - Excel 2007

©2009 About.com, a part of The New York Times Company.

All rights reserved.