Adjust row heights to make Excel spreadsheets easier to read

Are all the rows in your Excel spreadsheet crunched together? Mary Ann Richardson explains how to adjust the height of your rows to allow your numbers some breathing room—and your eyes a bit of white space to acclimate to the differences.

Excel automatically adjusts rows to the size of your font. If you don't want to increase the font and prefer to add white space between the rows to make your worksheets easier to read, you can insert an empty row between two lines of data. This works to a point—it could invalidate formulas that refer to values, which may change any time you insert a row. Rather than changing all the formulas' relative references to absolute values, a better alternative is to adjust row height; simply click and drag a row's boundary beneath the row's number until there is enough white space to easily read the data.

You can also change the height of more than one row. To do so, select the desired rows and then click and drag one of the selected row's boundaries until you reach the desired height. If you need to change the height of all the rows in a worksheet to make it more readable, click the Select All button in the upper left hand corner of the spreadsheet, then click and drag one of the selected row's boundaries to the desired height.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox