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 has been working with the ExcelDemy project for 4+ years. She has written and reviewed 1,500+ articles for ExcelDemy and has led several teams in Excel VBA and content development. She currently works as the Technical Content Specialist and Data Analyst for ExcelDemy, Statology, and KDnuggets, and oversees the site's technical content, forum, and YouTube content. Her work and learning interests range from automation in Microsoft Office, Google Workspace, and Excel to data analysis, data science,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo