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 4 - Formatting Text

You can format cells to change the way the text appears in a cell. You can change the font type, size, and style (bold, italics, underlined). In addition, you can also add special effects such as wrapping the text in a cell and having text merge in a selected number of cells. Since font changes are associated with the cell and not the contents, you can change the font before or after you enter information.

  • In Excel XP or MAC Excel 2004, to change the font formatting, select the cell or range you want to format, and use the Formatting Toolbar.

Excel XP Formatting Toolbar

Formatting toolbar

OR

  • In Excel XP or MAC Excel 2004, click on Format and choose cells. Select the Font tab. From this dialog box, you can change the font, the size, the style, and color. When you are finished changing the font formatting, click OK.

    Excel XP

Formatting font of the cells

  • In Excel 2007, under the Home tab you can use the groups to format the text within a cell or group of cells.

Excel 2007

Excel 2007 Format Cells

  • Or, click on one of dialog box launchers and choose a tab to format the text within a cell.
Module 5 Lesson 4 Section 3
Module 5 Lesson 4 Section 5

 

 
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