• 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

Adjusting Cell Height

1. Select the cell or column of cells by positioning your insertion point over the first cell in the column, holding Alt and dragging over the desired cells. A red frame will appear around the selected cells indicating they are selected.
2. On the Home tab, in the Content group, click Cell and then click the appropriate type tab, such as Numeric.

3. From the Cell Height pulldown, select:

   Variable	The cell height expands as necessary to accommodate larger font sizes.
   Exactly	Sets the cell height at a fixed size.
   At least	The height of the cell will expand as necessary to accommodate larger font sizes, but will be no smaller than the height specified.
   At Most	The cell will not expand past the height specified.

4. Type the height of the cell (if required) in the Cell Height box to the right.

Related Topics

• About Cell Formatting
• Adjusting Cell Width