I love your videos. Everything is so precise and to the point.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2010

Single page view print copy

Modifying Columns, Rows, and Cells

To modify the 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 the row height or upward decrease the row 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.

1 2 3 4 5 6 7