Is your MS Excel spreadsheet difficult to read? Does everything look all mushed together? Well help is on the way. I will show you how to adjust the height of your rows to give you more room and make it easier to read.
Some folks, in an effort to space their spreadsheets so that they are easier on the eyes, simply insert an empty row between two rows of data. While this does make the data easier to read and make the differences stand out, there are problems with this solution. Inserting an empty row between two rows of data could invalidate formulas that refer to values, which could change when you insert a new row.
The smarter way to add space to your spreadsheet rows of data is to adjust the row height and it is extremely easy to do.
- Just click and drag a row’s boundary beneath the row’s number until there is enough white space to easily read your data.
- To change the height of multiple rows, select the desired rows and then click and drag one of the boundaries of the selected rows until you are satisfied with the row height.
- If you want to change the height of all the rows in your worksheet, simply click the Select All button in the upper left-hand corner of the spreadsheet and then click and drag the boundary of one of the selected rows to the desired height.