How to Change the Row Height in Excel – 6 Methods

This is the sample dataset.

how to change row height in excel


Method 1 – Using Row Height Command

Steps:

  • Select B14:D14.
  • Go to: Home >> Cells >> Format >> Row Height.

using row height command to show how to change row height in excel

  • Set the Row Height to 50.
  • Click OK.

using row height command to show how to change row height in excel

This is the output.

using row height command to show how to change row height in excel

Read More: How to Change & Restore Default Row Height in Excel


Method 2 – Utilizing the AutoFit Row Height Command

Steps:

  • Select B14:D14
  • Go to: Home >> Cells >> Format >> AutoFit Row Height.

utilizing autofit row height command to show how to change row height in excel

This is the output.

utilizing autofit row height command to show how to change row height in excel

Read More: How to Auto Adjust Row Height in Excel


Method 3 – Using the mouse

Steps:

  • Go to row 14.
  • Double-click the row using the plus sign.

This is the output.

using mouse shortcut to show how to change row height in excel

Read More: Auto Row Height Not Working in Excel


Method 4 – Dragging the Mouse

Steps:

  • Go to row 14.
  • Drag down the plus sign to increase the height of the row.

by dragging mouse key or touchpad to show how to change row height in excel

This is the output.

by dragging mouse key or touchpad to show how to change row height in excel


Method 5- Using a Keyboard Shortcut

Steps:

  • Select B14:D14.
  • Press Alt+H+O+H.

  • Change the Row Height to 50.
  • Click OK.

This is the output.


Method 6 – Using the Context Menu

Steps:

  • Right-click row 14.
  • Choose Row Height.

  • Set the Row height to 50.
  • Click OK.

This is the output.

implementing context menu to show how to change row height in excel


Download Practice Workbook

Download the workbook.


Related Articles


<< Go Back to Row Height | Rows in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Shamima Sultana
Shamima Sultana

Shamima Sultana, BSc, Computer Science and Engineering, East West University, Bangladesh, has been working with the ExcelDemy project for 2 years. She has written over 75+ articles and reviewed 1000+ articles for ExcelDemy. She has also led several teams with Excel VBA and Content Development works. Currently, she is working as the Project Manager and oversees the day-to-day work, leads the services team, allocates resources to the right area, etc. Her work and learning interests vary from Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo