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. 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. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
