Skip to Content
Home
Maps
Calendar
Site Index / Search
Directory
  St. Edward's University

Computer Competency Requirement Navigation Bar
Competency Index
Competency Tutorial Index
Competency Glossary
Competency Site Index
Module 5 - Spreadsheets
Lesson 4 - Index Formatting Cells
Section 7 - Aligning Cell Contents

Text is automatically aligned with the left edge of the cell. Numbers are automatically aligned with the right edge. You can change the appearance of text and numbers by changing their alignment within the cell.

  • To change the alignment of the cell contents, click on the cell or range of cells you want to adjust.

In Excel XP or MAC Excel 2004, on the formatting toolbar:

  • The left alignment button will align the cell contents with the left edge of the cell.

Left Align Button

  • The right alignment button will align the contents with the right edge of the cell.

Right Align Button

  • The center alignment button will center the cell's contents within the cell.

Center Button

For more Aligning Options:

  • From the Format menu select Cells and click on the Alignment tab in the Format Cells dialog box.

Formating Cells window

  • Under the Text alignment section, choose the horizontal (side to side) and vertical (top to bottom) alignment of the cell contents. When you are finished, click OK.

In Excel 2007, under the Home tab choose an alignment from the alignment group.

  • The left alignment button will align the cell contents with the left edge of the cell.

Left Align Button

  • The right alignment button will align the contents with the right edge of the cell.

Right Align Button

  • The center alignment button will center the cell's contents within the cell.

Center Button

For more Aligning Options in Excel 2007:

  • From the Alignment group click on the Alignment dialog box launcher an d t he Format Cells dialog box will appear.

Excel 2007 Format Cells Dialog Box

  • Under the Text Alignment section, choose the horizontal (side to side) and vertical (top to bottom) alignment of the cell contents. When you are finished, click OK.

 

Module 5 Lesson 4 Section 6
Module 5 Lesson 4 Section 8

 

 
St. Edward's University Logo St. Edward's University
3001 South Congress Avenue
Austin, Texas 78704
512-448-8400
Contact: itccmail@stedwards.edu
Updated: 08/2007
© 2003, St. Edward's University