Have you ever opened a spreadsheet in Excel and seen a whole bunch of rows of varying sizes? I see this happen a lot when I open CSV files that contain a large amount of information. Not only does it make the sheet harder to read, it also dramatically increases the size of the spreadsheet, meaning you need to scroll much further.
You may have tried to go through a spreadsheet like this before and manually adjust each of the larger rows, but this can be time consuming and frustrating. Luckily you can take advantage of the ability to apply formatting to multiple rows at the same time, and quickly make all of the rows in the spreadsheet the same height.
How to Adjust the Row Heights for an Entire Excel Spreadsheet
The steps in this article were performed in Microsoft Excel for Office 365, but will also work in older versions of Excel as well. Note that I am going to be setting the height of my rows to 15, which is the default row height in Excel. However, you can manually set this row height to whatever value you would like.
Step 1: Open your spreadsheet in Excel.
Step 2: Click the gray button to the left of the column A heading, and above the row 1 heading. This selects the entire spreadsheet.
Step 3: Right-click on any row number, then choose the Row Height option.
Step 4: Enter a value for your row heights, then click the OK button.
Are you having trouble getting your columns to the correct size because the point size used for row height and column width is difficult to evaluate? Find out how to use inches to set column width and gain some additional control over the size of your cells.
Matthew Burleigh has been a freelance writer since the early 2000s. You can find his writing all over the Web, where his content has collectively been read millions of times.
Matthew received his Master’s degree in Computer Science, then spent over a decade as an IT consultant for small businesses before focusing on writing and website creation.
The topics he covers for MasterYourTech.com include iPhones, Microsoft Office, and Google Apps.
You can read his full bio here.