• Formatting
  • About Cell Formatting
  • Conditional Formatting
  • Adjusting Cell Height
  • Adjusting Cell Width
  • Aligning a Column of Cells
  • Aligning Numbers and Text in a Cell
  • Capitalizing Cell Contents
  • Changing a Cell's Font
  • Changing a Cell's Type
  • Changing The Separator for Date Cells
  • Creating a User Defined Underline
  • Defining Cell Options Globally
  • Distributing Cell Contents Evenly
  • Formatting The Appearance of Negative Values
  • Formatting The Appearance of Positive Values
  • Formatting The Appearance of Zero Values
  • Printing a Currency Sign Inside a Cell
  • Separating Large Currency Values with a Comma
  • Shading a Cell
  • Shading a Column of Cells in Form Mode
  • Shading Multiple Cells
  • Underlining a Cell
  • Underlining The Currency Symbol

Capitalizing Cell Contents

1. Select the cell you want to modify.

2. On the Home tab, click Cell, and then click Alphanumeric.

3. In the Capitalization list, select the type of capitalization to use.

• Normal: Sets format to allow a mix of capitals and lower case.

• Upper: Sets format as all uppercase

• Lower: Sets format as all lowercase

• Title: Capitalizes the first letter of each word

4. Click OK.

Tip: Capitalization may be changed for date cells as well. On the Home tab, in the Content group, click Cell and then click Date.

Related Topics

• About Cell Formatting