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.
Increase Row Size Numerically
Step 1: Right-click the row that number that you want to make bigger, then 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.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.