Changing Column Width and Row Height

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

Adjusting row height

Changing the row height is similar to adjusting column width. There will be times when you want to enlarge a row to visually provide some space between it and another row above or below it.

To adjust the height of a single row:

  • Place your mouse pointer to the lower edge of the row heading you want to adjust.
  • The mouse pointer changes to the adjustment tool.

    Selecting a Row's Broder
  • Drag the adjustment tool up or down to the desired height, then release the mouse button.

    Expanded Row Height

To AutoFit row height:

  • Place your mouse pointer to the lower edge of the row heading you want to adjust.
  • The mouse pointer changes to the adjustment tool.
  • Double-click to adjust the row height to autofit the font size.
  • Excel XP autofits the row, making the entire row slightly larger than the largest entry contained in the row.