• 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 Width

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 blue 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 Width drop-down list select:

   Variable	The cell will expand as necessary to accommodate the contents of the cell.
   Exactly	The width of the cell will not change regardless of its contents.
   At Least	The width of the cell will increase automatically as contents are input, but will not be less than the specified width.
   At Most	The width of the cell will increase automatically as contents are input, but will not expand more than the specified width.
   Column	The cell will be the same width as the column it is located in (for table cells).

4. Type the width of the cell (if required) in the Cell Width box to the right.

Related Topics

• About Cell Formatting
• Adjusting Cell Height