Excel Auto Fit Row Height for Wrap Text (4 Methods)

This article illustrates 4 different methods on how to auto-fit row height and column width of cells for wrap text in Excel. Following this article might be a great help for you if you often work with wrapped texts in Excel. Have a quick look through this article to learn how to do that quickly and save a lot of your time and effort. The following picture highlights the purpose of this article.

Excel Auto Fit Row Height for Wrap Text

Excel Auto Fit Row Height for Wrap Text: 4 Ways

Here I am going to highlight the methods for you. So let’s begin.

1.  Use Keyboard Shortcuts to Auto Fit Row Height of Wrap Text in Excel

  • Imagine you have copied some data from a source and pasted it on your worksheet as follows. The data contains the list of top ten books by American authors.

  • We have not got the desired result yet. Because the row heights of the cells containing wrap texts do not fit properly. To fix this issue, hold the Alt key and then press H, O, and A successively. Then you will see the following result.

Auto Fit the Row Height of Wrap Text with Keyboard Shortcuts in Excel

  • After that, you can press ALT+H+O+I to auto-fit the column widths.

2. Auto Fit Row Height of Wrap Text with Mouse-Click

  • You can also do that with just a double-click on the row separator line. First press CTRL+A+A to select the entire worksheet. Then put the mouse on the line separating the row numbers as shown below. Next, double-click on it. After that, the row heights will adjust automatically.

Auto Fit the Row Height of Wrap Text with Mouse-Click in Excel

  • You can also double-click on the line separating the column numbers to autofit the column widths as shown below.

3. Use Cell Formatting to Auto Fit Row Height in Wrap Text

Alternatively, you can get the same result using cell formatting. Just select the cells containing the wrap texts. Then select Format >> AutoFit Row Height or AutoFit Column Width from the Home tab.

 Auto Fit the Row Height of Wrap Text Using Cell Formatting

Read More: How to Wrap Text in Excel Cell

4. Add Magic Buttons from the Quick Access Toolbar to Auto Fit Row Height of Wrap Text

If you need to do this often, then you should probably add a magic button in the Quick Access Toolbar.

  • First, press ALT+F+T to open Excel Options. Then select the Quick Access Toolbar tab. Next, choose All Commands from the dropdown list. After that, scroll down to find the AutoFit Row Height or the  AutoFit Column Height command. Then select it and then click the Add button. After that, hit the OK button.

  • Now you will see a magic button added at the top left corner of the Excel window as a Quick Access Tool. You can use this button to auto-fit the row height of wrap texts in just one click.

Auto Fit the Row Height of Wrap Text with Magic Buttons

Things to Remember

  • AutoFit Row Height and AutoFit Column Width features in Excel do not work with merged cells. You need to manually adjust the row height or column width in that case. Excel shows this behavior by design.
  • If you apply autofit row height in a range of cells beforehand then the row height will adjust automatically whenever wrap text is applied in those cells.

Download Practice Workbook

You can download the practice workbook from the download button below.


Now you know 4 different methods on how to auto-fit row height or column width of wrap text in Excel. Please let us know which method you prefer the most. You can also use the comment section below for further queries or suggestions. Stay with us and keep learning.

Related Articles

<< Go Back to Wrap Text | Text Formatting | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

  1. Pressing the suggested shortcut (ALT+H+W) on Windows resulted in crushing my Excel and losing a document I spent the entire day working on… Unless the shortcuts work for all systems, you shouldn’t suggest them… Any thoughts (besides a basic look-up of recent files) on how I could restore this file? It currently opens a file with a blank screen.

    • Hi Anya,

      We regret to hear that. But you may have used the wrong shortcut. If you press ALT+W+H instead of ALT+H+W, then it will hide the window. Press ALT+W+U, then select the workbook in the popup window and click OK to unhide the window. Alternatively, you can click on Unhide from the Window group in the View tab.

      I suggest you to make sure you are using the right shortcut before using any from next on. How can you do that? Well, if you press the Alt key, then you should see letters beside each tab on the Ribbon as the shortcut to go to that tab. Now press the letter visible beside the tab that you need to go. After that, you should see the shortcut letters visible beside each command on that tab. This way you will know if this is the right shortcut for the task.

      Hope this solves your problem. If not then please let us know with details. We will try our best to help you fix that.

      Md. Shamim Reza (ExcelDemy Team)

Leave a reply

Advanced Excel Exercises with Solutions PDF