1. Computing

Changing Cell Alignment of Data in Excel

By

Basic Excel 2010 Ecourse Tutorial Step 10
Changing Cell Alignment of Data

Changing Cell Alignment of Data

© Ted French

Changing Cell Alignment of Data in Excel

The default alignment of text data, such as labels and column titles is on the left side of a cell.

Numbers, formulas, and dates, which are referred to as values, are right aligned by default.

These default alignments are not always the best choice for your data, so Excel makes it easy to improve the layout and appearance of a worksheet by using the cell alignment icons on the Home tab of the ribbon.

In the previous step, we used the merge and center option to center the worksheet title.

In this step we will use the cell alignment icons to center and right align data in order to improve the appearance of the worksheet and to make it easier to read the data.

Tutorial Steps:

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

  1. Drag select cells B3 to B5 to highlight the Date and Deduction Rate labels.

  2. Click on the Align text right option on the ribbon to right align these labels.

  3. Drag select cells C3 to C5 to highlight the values in cells C3 and C5.

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

  5. Drag select cells A7 to F11.

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

©2014 About.com. All rights reserved.