How to Adjust Row Height in Excel - 4 Easy Ways for Beginner

Written By Sophanith Dith
Last Updated July 05, 2026
Applies to Microsoft Excel 365 (Windows only)
Part of the Beginner Learning Path
Module 3 Formatting and Layout
Lesson 10 of 14

Table of Contents

Have you ever typed something in Excel and noticed that the text looks cut off, squeezed, or hidden behind the next row? This can make your worksheet look messy and harder to read, especially when you have long names, notes, descriptions, or wrapped text.

Learning how to adjust row height in Excel helps you control the vertical space in your worksheet. You can make a row taller, make it shorter, set an exact height, or let Excel automatically fit the row to the content inside the cells.

This skill is useful when you want your spreadsheet to look clean, readable, and easier to present. It is also one of the basic layout skills every beginner should learn before working with larger worksheets.

In this tutorial, you will learn the easiest ways to change row height in Excel, when to use each method, and how to avoid common beginner mistakes.

Quick Answer:
To adjust row height in Excel, select the row, then drag the bottom border of the row heading up or down. You can also go to Home → Cells → Format → Row Height to enter an exact height, or choose AutoFit Row Height to make Excel adjust the row automatically.

Quick Reference

Before going step by step, here is a quick overview of the main ways to resize rows in Excel. This gives you the basic idea before you practice each method.

Drag the row boundary to manually make a row taller or shorter.
Double-click the row boundary to AutoFit the row height.
Use Home → Cells → Format → Row Height to enter an exact height.
Use Home → Cells → Format → AutoFit Row Height to fit content automatically.
Select multiple rows first if you want to adjust several rows at the same time.
Use AutoFit when text is hidden or wrapped across multiple lines.

These methods are simple, but each one is useful in a slightly different situation.

What Row Height Means in Excel

Row height controls how tall a row appears in your worksheet. When you increase row height, the cells in that row get more vertical space. When you decrease row height, the cells become shorter.

In Excel, rows are identified by numbers on the left side of the worksheet. These numbers are called row headings. For example, the number 1 represents row 1, the number 2 represents row 2, and so on.

If a row is too short, some content may appear hidden or crowded. If a row is too tall, the worksheet may look stretched out and harder to scan.

For example, suppose you have employee notes in column C. If one note is longer than the others, the row may need more height so the full note is visible. Adjusting row height makes the worksheet easier to read without changing the actual data.

Beginner Tip:
Row height changes the appearance of the row, not the value inside the cells. Your data stays the same.

If you already learned how to resize columns, this lesson works in a similar way. You can review the previous lesson here: how to adjust column width in Excel.

How to Adjust Row Height in Excel Manually

The fastest way to adjust row height is to drag the row boundary with your mouse. This method is best when you want to quickly make a row taller or shorter by sight.

Manual resizing is useful when you do not need an exact measurement. You simply drag until the row looks right.

Steps to Manually Change Row Height

Follow these steps when you want to resize one row quickly.

Move your mouse pointer to the row number on the left side of the worksheet.
Place the pointer on the bottom border of the row heading.
Wait until the pointer changes into a vertical resize arrow.
Click and drag the border down to make the row taller.
Drag the border up to make the row shorter.
Release the mouse button when the row height looks right.

For example, if row 5 contains a long product description, you can place your mouse on the bottom border of row 5 and drag downward. This gives row 5 more space so the content is easier to see.

Beginner Warning:
Be careful not to drag the wrong row boundary. The row you resize is the row above the border you are dragging.

Manual adjustment is simple, but it may not be the best choice when you need consistent row sizes across many rows.

How to Set an Exact Row Height in Excel

Sometimes you may want several rows to have the same height. In that case, setting an exact row height is better than dragging manually.

This method is useful for forms, checklists, printable sheets, and worksheets where consistent spacing matters. Instead of guessing with your mouse, you enter a specific row height value.

Steps to Set a Specific Row Height

Use this method when you want a precise row height.

Select the row or rows you want to adjust.
Go to the Home tab.
In the Cells group, click Format.
Under Cell Size, click Row Height.
Type the row height value you want.
Click OK.

For example, if you are creating a simple attendance sheet, you might set rows 2 through 20 to the same height so the list looks neat and balanced.

Beginner Tip:
You do not need to select the entire worksheet unless you want every row to use the same height. Select only the rows you want to change.

A specific row height gives you control, but sometimes Excel can do the adjustment for you automatically.

How to AutoFit Row Height in Excel

AutoFit Row Height tells Excel to automatically adjust the row height so the content fits inside the row. This is one of the most helpful row height tools for beginners.

If text is hidden, wrapped, or spread across multiple lines, AutoFit can quickly make the row tall enough to show the content. This is why many beginners search for how to autofit row height in Excel when their text does not display correctly.

Method 1: AutoFit Row Height from the Ribbon

This method uses the Excel Ribbon and is easy to follow if you prefer menu commands.

Select the row or rows you want to adjust.
Go to the Home tab.
In the Cells group, click Format.
Under Cell Size, click AutoFit Row Height.

Excel adjusts the selected rows based on the content inside them.

For more details, you can review Microsoft’s official guide to change the column width and row height, which also explains AutoFit Row Height.

This is a good method when you want a clear, menu-based way to fix row height. It is also easy to explain in a tutorial or follow while watching a video.

Method 2: AutoFit Row Height by Double-Clicking

There is also a faster way to use AutoFit with your mouse.

Move your mouse pointer to the bottom border of the row heading.
Wait until the pointer changes into a vertical resize arrow.
Double-click the row boundary.

Excel automatically resizes the row to fit the tallest content in that row.

This method is fast and practical when you only need to fix one row. It is also one of the easiest ways to use autofit row height in Excel without opening any menu.

Beginner Warning:
If the row still does not look right after AutoFit, check whether text wrapping, merged cells, or manual formatting is affecting the result.

AutoFit is helpful for fixing content visibility, but there are times when you may want to adjust several rows together.

How to Adjust Multiple Row Heights at Once

When you work with a larger worksheet, adjusting rows one by one can take too much time. Excel lets you select multiple rows and resize them together.

This method is useful when you want a clean, consistent layout across a section of your worksheet. For example, you may want all rows in a checklist, schedule, or product list to have the same height.

Steps to Change Multiple Rows Manually

Use this method when several rows should have the same visual height.

Select the row numbers you want to adjust.
Place your mouse pointer on the bottom border of any selected row heading.
Drag the border up or down.
Release the mouse button.

All selected rows change to the same height.

For example, if you select rows 2 through 10 and drag the bottom border of row 10, Excel applies that height to all selected rows.

Steps to AutoFit Multiple Rows

Use this method when several rows contain different amounts of content and each row should fit its own content.

Select the rows you want to AutoFit.
Go to the Home tab.
Click Format in the Cells group.
Click AutoFit Row Height.

Excel checks the content in each selected row and adjusts the row height as needed.

This is especially helpful when some rows contain short entries and others contain longer text.

If you are working through the full beginner roadmap, this is a good place to understand how layout skills support data entry and readability. You can continue building these basics in the Beginner Excel Learning Path.

When to Use Manual Row Height vs AutoFit Row Height

Manual row height and AutoFit Row Height both resize rows, but they are useful in different situations. Choosing the right method helps you work faster and avoid unnecessary formatting problems.

The table below compares the most common beginner scenarios.

Situation	Best Method	Why
You want a row to look taller for design reasons	Manual drag	You can control the appearance by sight
You need several rows to have the same height	Row Height command	You can enter one exact value
Text is hidden or cut off	AutoFit Row Height	Excel adjusts the row to show the content
Wrapped text needs more space	AutoFit Row Height	Excel fits the row to the wrapped lines
You are preparing a neat printable checklist	Exact Row Height	Consistent spacing looks cleaner
You are quickly fixing one row	Double-click row boundary	It is the fastest AutoFit method

For most everyday worksheets, the best approach is simple: use manual resizing for appearance and use AutoFit when content is not fully visible.

Beginner Tip:
If you are unsure which method to use, try AutoFit first. If the result looks too tall or too short for your design, adjust the row manually afterward.

Common Problems When Adjusting Row Height

Even though row height is simple, beginners often run into a few confusing situations. Knowing these problems helps you fix your worksheet faster.

These issues usually happen because Excel is trying to balance content, formatting, and layout rules at the same time.

Text Still Looks Hidden After Changing Row Height

If text still looks hidden, the column may be too narrow, or the text may not be wrapped. Row height controls vertical space, but column width controls horizontal space.

For example, if a sentence is too long for a narrow column, increasing row height alone may not make it easier to read. You may also need to widen the column or use Wrap Text.

To learn the related column skill, see how to adjust column width in Excel.

AutoFit Row Height Does Not Look Right

Sometimes excel row height autofit may not give the result you expected. This can happen when cells contain merged cells, unusual formatting, or content that does not behave like normal text.

If AutoFit does not work well, try these fixes:

Check whether the cell uses Wrap Text.
Look for merged cells in the row.
Manually drag the row boundary if needed.
Use the Row Height command for a specific value.

Beginner Warning:
Merged cells can make row and column adjustments less predictable. If you are building a clean data worksheet, use merged cells carefully.

Rows Look Uneven After Editing Data

Rows may look uneven after you add or remove long text. This is normal because some rows need more space than others.

If you want the worksheet to look consistent, select the rows and set one exact row height. If you want every row to fit its content, use AutoFit Row Height instead.

Row Height Changes After Wrapping Text

When text wraps onto more than one line, Excel may need a taller row to show all the text. This is expected behavior.

A full lesson on wrapping text belongs in a separate tutorial, but the basic idea is simple: Wrap Text lets long content appear on multiple lines inside the same cell. After that, AutoFit Row Height can make the row tall enough to display those lines.

You can continue with the next lesson here: how to wrap text in Excel.

Best Practices for Clean Row Height Formatting

Good row height formatting makes a worksheet easier to read without drawing attention to itself. Beginners often focus only on the data, but layout also affects how professional the worksheet feels.

The goal is not to make every row large. The goal is to give each row enough space for the content while keeping the worksheet easy to scan.

Keep Similar Rows Consistent

If your worksheet has a list, table-like range, or simple form, try to keep similar rows the same height. This makes the layout easier to follow.

For example, in a customer contact list, rows with customer names, phone numbers, and email addresses usually look better when they have the same height.

Use AutoFit for Long Notes

If some rows contain longer notes or descriptions, AutoFit is usually better than guessing manually. It helps prevent hidden text and saves time.

This is especially useful when you paste data from another source and the row spacing no longer looks correct.

Avoid Making Rows Too Tall

Rows that are too tall can make a worksheet harder to scan. Readers may need to scroll more, and the data may feel spread out.

Use taller rows only when the content needs more space or when the worksheet design requires it.

Check the Worksheet After Editing

After adding new text, deleting content, or changing formatting, quickly review the row heights. A worksheet that looked clean before may need small layout adjustments after editing.

This habit is especially helpful before printing, sharing, or taking screenshots for a report.

Quick Practice

Practice helps you remember the difference between manual row height and AutoFit. Try the short exercise below in a blank worksheet.

Open a blank Excel worksheet.
Type Product Notes in cell A1.
Type a long sentence in cell A2, such as This product note is longer than usual and needs more space to display clearly.
Move your mouse to the bottom border of row 2.
Drag downward to make row 2 taller.
Double-click the bottom border of row 2 to AutoFit the row height.
Select rows 3 through 6.
Go to Home → Cells → Format → Row Height.
Type a row height value and click OK.

This short practice shows you the three most important row height skills: dragging, AutoFit, and setting an exact height.

Key Takeaways

Row height is a basic Excel layout skill that helps make worksheets cleaner and easier to read.

Row height controls the vertical space in a row.
You can drag a row boundary to resize a row manually.
You can use Home → Cells → Format → Row Height to enter an exact value.
You can use AutoFit Row Height to make Excel fit the row to its content.
Double-clicking a row boundary is the fastest AutoFit method.
If text still looks hidden, you may also need to adjust column width or use Wrap Text.
Consistent row height makes lists, forms, and simple worksheets look more organized.

Frequently Asked Questions (FAQs)

How do I adjust row height in Excel?

To adjust row height in Excel, move your mouse to the bottom border of the row heading, then drag up or down. You can also select the row and go to Home → Cells → Format → Row Height to enter a specific height.

How do I auto adjust row height in Excel?

To auto adjust row height in Excel, select the row or rows, then go to Home → Cells → Format → AutoFit Row Height. Excel will resize the selected rows based on the content inside them.

What is the fastest way to AutoFit row height in Excel?

The fastest way is to double-click the bottom border of the row heading. Excel automatically adjusts the row height to fit the content in that row.

Why is my text still cut off after I change row height?

The column may be too narrow, the text may not be wrapped, or the row may contain formatting that affects how the content appears. Try widening the column or using Wrap Text, then use AutoFit Row Height again.

Can I adjust multiple row heights at the same time?

Yes. Select the rows you want to change, then drag the bottom border of one selected row heading. You can also use Home → Cells → Format → Row Height to give all selected rows the same height.

Does changing row height change my data?

No. Changing row height only changes how the worksheet looks. It does not change the values, formulas, or text inside the cells.

Conclusion

Learning how to adjust row height in Excel is a simple but important layout skill. It helps you make rows taller, shorter, more consistent, or automatically fitted to the content inside your worksheet.

For beginners, the most useful methods are dragging the row boundary, using Row Height for exact spacing, and using AutoFit Row Height when text is hidden or wrapped. Practice each method a few times, and you will quickly know which one to use in different worksheet situations.

To continue building your Excel foundation in order, visit the Beginner Excel Learning Path. For the next related layout skill, continue with How to Set Page Orientation and Margins.