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.

how to start your own website
Have you ever wanted your own blog or website? Click here to learn how to get started today and have you own domain in less than 20 minutes!