How to Make a Row Bigger in Excel 2010

Adjusting the size of the cells in your spreadsheet is a pretty common occurrence, so you will eventually need to know how to make a row bigger in Excel 2010. Whether it is due to an increased font size or multiple lines of data, it is something that can make your spreadsheet much easier to read.

There are a few different ways to make a row bigger in Excel, and we will explore several of them in our tutorial in this article. If you need to make a row bigger for printing reasons, then we recommend checking out this simple guide to Excel printing for some common fixes that improve the printability of your spreadsheets.


Make a Row Bigger in Excel 2010

You have the option of visually making your row bigger, entering a higher value to increase the size of the row, or allowing Excel to automatically resize the row for you. The correct option is situational, so check out all of the different methods of making an Excel 2010 row bigger below. You can visit Microsoft’s website to learn more about resizing columns and rows.


Increase Row Size Visually

Step 1: Open the spreadsheet containing the row that you want to make bigger.


Step 2: Click the border at the bottom of the row number, then drag it down to increase the size of the row.

click and drag the bottom border of the row number



Increase Row Size Numerically

Step 1: Right-click the row that number that you want to make bigger, then click the Row Height option.

click the row height option



Step 2: Enter a new value into the field, then click the OK button. Note that this number is the number of pixels, which is a unit of measurement with which most people are not familiar. You may need to experiment with different values before you find the appropriate size for your row.

enter a new row height



Have Excel Increase the Row Size Automatically

Step 1: Locate the row that you want to make bigger.


Step 2: Double-click the bottom border of the row number. Excel will automatically resize the row so that all of the data is visible. Note that it will only automatically resize the row. You may also need to resize columns using similar methods to those in this article.

double-click the bottom border of the row number



Do you want to quickly resize all of your columns? This article offers a quick solution for anyone that wants all of their columns to autofit the data contained within them.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.