Adjusting Column Width and Row Height

In Excel column width can be modified, as can row height and width in Excel. Learn to modify Excel cells in this free Excel 2000 lesson.

Adjusting column width two ways

Manually:

  • Place your mouse pointer to the right side of the column header.
  • The mouse pointer changes to the adjustment tool (double-headed arrow).
  • Drag the edge of the column header to the desired width and release the button.

AutoFit:

  • Place your mouse pointer to the right side of the column header.
  • The mouse pointer changes to the adjustment tool (double-headed arrow).
  • Double-click the column header border.
  • Excel autofits the column, making the entire column slightly larger than the largest entry.

Important pointTo access AutoFit from the menu bar, choose FormatLesson ActionColumnLesson ActionAutoFit Selection.

AutoFit's double-headed arrow