Modifying Columns, Rows, and Cells

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

To modify row height:

  1. Position the cursor over the row line so the white cross Cursor becomes a double arrow Double-arrow.
    Positioning the mouse over the row line Positioning the mouse over the row line
  2. Click and drag the row downward to increase row height or upward to decrease height.
    Increasing the row height Increasing the row height
  3. Release the mouse. The height of each selected row will be changed in your worksheet.
    Increased row height Increased row height

To set row height with a specific measurement:

  1. Select the rows you want to modify.
  2. Click the Format command on the Home tab. The format drop-down menu appears.
  3. Select Row Height.
    Increasing the column width Increasing the column width
  4. The Row Height dialog box appears. Enter a specific measurement.
    Increasing row height to 60 pixels Increasing row height to 60 pixels
  5. Click OK. The selected rows heights will be changed in your spreadsheet.

Select AutoFit Row Height from the format drop-down menu, and Excel will automatically adjust each selected row so all of the text will fit.