AutoFitting Data Within Cells
When a cell contains a number, date, or time that is wider than it is or when the cell contains a date or time formula that produces a negative result, Excel will display a series of pound signs (####). You can easily readjust the width of the column to fit the cell value using the Autofit function.
  1. Move the mouse to the right side of the cell’s column header (the gray area that lists the column letters). For example, if the cell’s address is B4, then move the mouse to the column header between column B and C.
  2. The cursor will become a double-headed arrow.

  3. With the double-headed arrow between the two column headers, double-click.
  4. The column to the left of the double-headed arrow will automatically increase in width to accommodate the longest cell value in that column.

Click HERE to return to the Table of Contents.