GCFLearnFree.org

Every day I fall a little more in love with your site.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2003
  • Text and Cell Alignments

Excel 2003

Single page view print copy

Text and Cell Alignments

Changing horizontal cell alignment

We've previously seen how to align text or numbers using the left-align, center, and right-align buttons in the Standard toolbar. You can also define alignment in the Alignment tab of the Format Cells dialog box.

Horizontal Alignment Examples

The Horizontal section features a drop-down menu that contains the same left, center, and right alignment options in the picture above and several more:

Fill

"Fills" the cell with the current contents by repeating the contents for the width of the cell.

Justify

If the text is larger than the cell width, Justify wraps the text in the cell and adjusts the spacing within each line so all lines are as wide as the cell.

Center across selection

Contents of the cell farthest to the left are centered across the selection of cells. This function is similar to Merge and Center, except the cells are not merged.

To change horizontal alignment using the Format Cells dialog box:

  • Select a cell or range of cells.
  • Choose Format Cells from the menu bar.

    Formal and Cells Menu Selections

    (You could also right-click and choose Format Cells from the shortcut menu.)
  • The Format Cells dialog box opens.
  • Click the Alignment tab.

    Alignment Tab on the Format Cells Dialog Box

  • Click the Horizontal drop-down menu, and select a horizontal alignment treatment.
  • Click OK to apply the horizontal alignment to the selected cell(s).
previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.