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.
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.
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.