You may already know that you can change the height of a row in Microsoft Excel 2010, but it can be tedious when you need to change the height of every row in your spreadsheet. Fortunately if you are making each row the same height, there is a much faster way to do it.
Our guide below will show you how to select your entire spreadsheet, then simultaneously change the height of each row so that they are the same height. This will work regardless of whether the rows are already the same height, or if each row has a different height.
Set All Rows to One Height in Excel 2010
Another option for automatically changing the height of each row is to use the Autofit Row Height option. This article was written for Excel 2013, but the instructions are the same for Excel 2010. Using the Autofit Row Height option will automatically resize your rows based upon the data that is contained within them. This is a more preferable option when you have rows that contain varying heights of data.
Step 1: Open your spreadsheet in Excel 2010.
Step 2: Click the button at the top-left corner of the spreadsheet, between the 1 and the A, to select all of the rows and columns in the spreadsheet. It is the button pointed out in the image below. If you only want to change the height for some of your rows, then you will instead need to select those row numbers at the left side of the spreadsheet.
Step 3: Right-click one of the selected rows, then click the Row Height option.
Step 4: Enter the desired row height value into the field, then click the OK button. Note that the unit of measurement for the row height is in points, an unfamiliar unit of measurement for many people, so you may need to try a few different sizes until you find one that is appropriate for your needs.
Does your spreadsheet contain a lot of unwanted format, and you would rather just start with a clean slate? This guide will show you how to clear cell formatting in Excel 2010.
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.