• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Change Row Height in Excel

August 26, 2021 by Andrew Childress
Change row height Excel

Sometimes, your rows will need a bit more room to breathe. That makes it easier to read data, Here's how to change row height in Excel.

Sometimes, your rows will need a bit more room to breathe. That makes it easier to read data and space your spreadsheet properly. It’s easy to resize those rows so that your content isn’t crowded or overly space. Let’s learn how to change row height in Excel.

Change Row Height in Excel

Are your rows feeling a bit crowded? Or maybe that they have too much space? In either case, you can resize your row height with just a few clicks.

On the side of Excel, you’ll see each row has its own number. To change the row height, hover your mouse cursor over the edge of a row until you see your arrow shown as a double arrow. Once you have the double arrow icon, click and drag to resize the selected row. Check out the animation below to see an example.

Change row height Excel

Notice while you’re hovering that Excel gives you a preview of the pixel height of the row. It’s a good way to check the size of a row and match others against it in the future so that your rows aren’t widely varying sizes.

Also, you can double-click with the double arrow showing to automatically resize the row. This will match the row height to the content inside of it. This is the easiest way to size a row based on what’s inside of it.

Change Multiple Row Height in Excel

Sometimes, you’ll need to adjust several rows at the same time. Consistency makes your spreadsheet more visually appealing and easier to follow, and that includes making your rows the same height.

Select multiple rows by holding Control on your keyboard on Windows, or Command on macOS and click on several rows. Then, follow the same steps to resize the rows. You’ll see that each row is now resized once you release the mouse.

Resize multiple rows Excel

You’ll notice that every row is now the same size. This is a great way to not only resize the rows but also keep your spreadsheet consistent.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Hide worksheets in ExcelHow to Hide Worksheets in Excel
Next Post:Add Audio in ExcelCreate from file audio

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top