How To Adjust Excel WorkSheet Row Height And Column Width

There are three ways to adjust excel worksheet row height and column width as below. I will tell you how to do it one by one with example in this article.

  1. Adjust it by hand.
  2. Adjust it by ribbon menu item.
  3. Adjust it by popup menu item.

1. Adjust Excel WorkSheet Row Height And Column Width By Hand Steps.

  1. Move the mouse pointer to the lower edge of the row number to be adjusted. When an arrow appears, drag the mouse pointer up and down to adjust the row height.
  2. If you want to adjust multiple rows height at same time, you should first select multiple excel worksheet rows ( select the whole rows not part of the rows  ) and then click Home —> Format —> Lock Cell menu item to lock your selected rows. Then you can adjust the multiple rows height like step 1.
    change-height-multiple-rows
  3. Adjust excel worksheet column width is similar as adjust row height, move the mouse pointer to the end edge of one column, when there is an arrow appear, drag the arrow left and right to adjust the column width.
  4. If you want to adjust multiple excel worksheet columns width at same time, you should first select the multiple columns ( not only the multiple column cells but the whole column ) and then click Home —> Format —> Lock Cell menu item to lock them, then you can adjust the multiple selected columns width as step3.
    change-width-multiple-columns

2. Adjust Excel WorkSheet Row Height And Column Width By Ribbon Menu Item Steps.

  1. Click the cell where you want to adjust the row height or column width.
  2. Click Home —> Format —> Row Height / Column Width menu item.
    excel home - format - row height menu item
  3. Input the new row height or column width value in the popup alert dialog, click OK button to apply the new value, then you can see the row height or column width changed immediately.
  4. If you want to adjust multiple rows height or columns width, you just need to select multiple cells and then change the value as step 3.

3. Adjust Excel WorkSheet Row Height And Column Width By Popup Menu Item Steps.

  1. Select the entire row or multiple rows in the excel worksheet.
  2. Click the right mouse key.
  3. Click Row Height menu item in the popup menu list.
    change rows height popup menu item
  4. Input row height number in the popup alert dialog.
  5. Select the entire column or multiple columns in the excel worksheet.
  6. Click right mouse key.
  7. Click Column Width menu item in the popup menu list.
  8. Input the column width value in the alert dialog. Click OK button to apply it.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.