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 2016 lesson.

To modify row height:

  1. Position the cursor over the row line so the white cross Cursor becomes a double arrow Double-arrow.


    Screenshot of Excel 2013Hovering the mouse over the row line
  2. Click, hold, and drag the mouse to increase or decrease the row height.


    Screenshot of Excel 2013Increasing the row height
  3. Release the mouse. The height of the selected row will be changed.


    Screenshot of Excel 2013The new row height

To modify all rows or columns:

Rather than resizing rows and columns individually, you can modify the height and width of every row and column at the same time. This method allows you to set a uniform size for every row and column in your worksheet. In our example, we will set a uniform row height.

  1. Locate and click the Select All button select all button just below the formula bar to select every cell in the worksheet.


    Screenshot of Excel 2013Selecting every cell in a worksheet
  2. Position the mouse over a row line so the white cross Cursor becomes a double arrow Double-arrow.
  3. Click, hold, and drag the mouse to increase or decrease the row height.


    Screenshot of Excel 2013Modifying the height of all rows
  4. Release the mouse when you are satisfied with the new row height for the worksheet.


    Screenshot of Excel 2013The uniform row height