1. Computing

Excel Basic Step by Step Tutorial

By , About.com Guide

7 of 9

Changing Data Alignment
Changing Data Alignment in Excel

Changing Data Alignment in Excel

© Ted French

Excel Formatting - Changing Data Alignment

  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.

©2013 About.com. All rights reserved.