Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Change Row Height in Excel? 5 Easy Ways

How to Change Row Height in Excel? 5 Easy Ways

(Note: This guide on how to change row height in Excel is suitable for all Excel versions including Office 365)

Excel consists of a multitude of cells. These cells are arranged in rows and columns for easy data entry and retrieval. 

By default, the rows and columns appear with a specific height and width. Sometimes, when you enter data in the cells, the rows and columns might adjust to the height and width of the content. In most cases, the content will be hidden unless you enter the edit mode or double-click on the cell. In some cases, this can even cause a # error. 

When the data in multiple cells exceed the display width, it’ll be hard to view the data. This hinders the readability of the data and makes the data look incomplete.

In such cases, you can change the row height or the column width to make the data in the cell easily readable to the user. 

In this article, I will tell you how to change row height in Excel.

You’ll Learn:

  • How to Change Row Height in Excel?
    • By Clicking and Dragging
    • By Double Clicking
    • By Using AutoFit Rows
    • By Changing the Row Height Manually
    • Using Excel Hotkeys

Watch this short video on How to Change Row Height in Excel

Related Reads:

How to Make Excel Track Changes in a Workbook? 4 Easy Tips

How to Split Cells Diagonally in Excel? 2 Easy Ways

How to Merge Cells in Excel? 3 Easy Ways

How to Change Row Height in Excel?

There are a variety of ways to change row height in Excel. Some methods are used to change the row height for particular cells, whereas others help to change the row height or column width to suit the data in the cells.

Let us see each method in detail with an example.

Consider an Excel workbook that has the following data.  

Example
Example

At first glance, it seems as though the data perfectly fit in each cell. Upon taking a closer look, it can be seen that the data visible to the user is not the actual data. Some of the text is hidden within the cells, which makes it difficult for the reader to understand and infer the contents of the cell.

In these cases, changing the row height and column width will enable you to understand the complete data. Let us see each method in detail.

By Clicking and Dragging

This is a prevalent and frequently used way to change row height or column width in Excel. By clicking and dragging, you can change the height and width of cells in Excel.

  • First, identify the cell that you want to change the height or width of. 
  • If you want to change the row height, place your cursor on the row headings on the left side of the sheet. And, in case you want to change the column width, move the cursor to the column headings on the top of the sheet.
Click and drag the row or column headers
Click and drag the row or column headers
  • Once you hover over the row or column headers, you can see the mouse pointer change to a double-sided resize pointer. 
  • Now by holding the left mouse button, drag to the desired height/width. 
  • Leave the mouse button.
  • This sets the height of the particular row. 

In the same way, you can set the column width to get a perfect readable view.

Change row height in Excel by clicking and dragging
Change row height in Excel by clicking and dragging

This method is a simple and easy method to change the row height. However, one drawback to this method is that when data is large, you have to click and drag every row. Also, when you change the height of one particular row, the other row’s height might get altered. 

Let us now see the other methods to change the row height in Excel.

By Double Clicking

This is a very fast and easy method to change row height in Excel. Instead of altering the row height or column width, this method sets the height or width to perfectly fit the content in the cell.

  • Place the mouse pointer in between the rows where you want to change the height. 
  • You can see the mouse pointer change to a double-sided resize pointer. 
  • Double click on the place and you can see the row height change to fit the content in the cell. You can see that if the row or column is expanded, double-clicking on the row shortens it. On the other hand, if the row is shortened, double-clicking expands it.

Note: To adjust the row height for multiple cells together, select all the cells and double-click on the row header. 

By Using AutoFit Rows

In most cases when changing the row height, you would aim to make the contents of the cell visible. Double-clicking on the rows/column fits the rows and columns to the perfect height. Let us see how.

  • Select the cells you want to adjust the height. 
  • Navigate to Home. Under the Cells section, click on the dropdown from Format. 
  • Since we want to adjust the row height, click on AutoFit Row Height. 
Change row height in Excel using AutoFit Rows
Change row height in Excel using AutoFit Rows
  • This instantly adjusts the row height to fit the content of the cells. This way, you can adjust the row height for any number of cells altogether. 
Row height is changed to fit the content
Row height is changed to fit the content

Suggested Reads:

How to Unmerge Cells in Excel? 3 Best Methods

How to Enable Full Screen in Excel? 3 Simple Ways

How to Insert a Hyperlink in Excel? 3 Easy Ways

By Changing the Row Height Manually

When you change the row height by clicking and dragging or by double-clicking, you will not know the height or width value you set the rows or columns to. There might be times when you have to set the row height or column width to a specific value.

  • First, select the rows that you want to change the height. To do this, navigate to the row header where you can see the mouse pointer change to an arrow. 
  • Left-click and hold the mouse button to select the rows.
  • Now, right-click on the row headings and select Row Height.
How to change row height in Excel manually
How to change row height in Excel manually
  • Another way to select Row Height is by navigating to Home. Under the Cells section, click on the dropdown from Format and select Row Height.
  • This opens the Row Height dialog box. 
  • Specify the row height you want and click OK.
Set to specific value
Set to specific value
  • This sets the row height to the specific units you have entered.
  • If you are not satisfied with the row height, you can select the rows, change the value again, and click OK. 
The row height is changed
The row height is changed

One advantage is that when you use this method and set the row height, all the rows will have the same height. This helps the rows and columns look aesthetically similar as they all have uniform spacing. 

Using Excel Hotkeys

Keyboard shortcuts always help in quick and efficient ways to solve problems. Using keyboard shortcut keys also known as hotkeys, you can change the row height in Excel. 

  • Open the worksheet. 
  • Select the rows you want to change height either by clicking on the left mouse button and dragging them. Or hold shift and use the arrow keys to select the rows.
  • Press the ALT key. This opens the hotkeys layout in the Excel window.
  • Now press H and then O. This opens the Format dropdown. 
  • You can see the keyboard shortcut keys which correspond to specific options in the Format dropdown. If you want to set the row height to a specific value, press H. In case you want to autofit the row height to the content in the cells, press A.
Change row height in Excel using Hotkeys
Change row height in Excel using Hotkeys

Note: In the same way, you can change the column width easily using the shortcut keys. Press the keys Alt + H + O + W one after the other to change the column width. 

Also Read:

How to Save Excel Chart as Image? 4 Simple Ways

How to Create Excel Drop Down List With Color?

How to Save Excel as PDF? 5 Useful Ways

Frequently Asked Questions

Why cannot I alter the row height in Excel?

You cannot alter the row height or column width when entering the edit mode in any cell. To exit the edit mode, click anywhere outside the particular cell or click on the row or column headings. When you see a single selection arrow or a double-sided resize arrow, you can change row height in Excel.

What is the easy and efficient way to change row height in Excel so that all content is visible?

The easiest and most efficient way to change the row height to fit the content is by selecting all the rows you want to change the height and double-clicking on the row. This changes the row height to fit the contents of the cell in an instant.

Can I change row height in Excel just by using keyboard shortcuts?

Yes, you can change the row height using the keyboard shortcut keys. Select the rows by holding the Shift key and using the arrow keys to select the cells. Then, press the shortcut keys Alt+H+O+H to set the row height manually. If you want to autofit the row height, press the keys Alt+H+O+A.

Closing Thoughts

Changing the row height or column width is a very essential feature. This helps simplify large amounts of data that may be hidden or intertwined in the cells, confusing the users. Simplified data, on the other hand, is easy for the user to read, understand, and perform operations to. 

In this article, we saw how to change row height in Excel in 5 easy ways. Using the same methods, you can also change the column width. Depending on your preference and purpose, choose the method that suits you the best.

If you need more high-quality Excel guides, please check out our free Excel resources center. Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 140+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Count Unique Values in Excel? 3 Easy Ways to Count Unique and Distinct Values

Using the LET Function in Excel

How to Use FLOOR Function in Excel? 2 Easy Ways

How to Group Worksheets in Excel? (In 3 Simple Steps)

Reconcile a Bank Account in Quickbooks Pro 2012

XLOOKUP Google Sheets – 4 Best Alternatives!

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)