Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
Rows are central to your worksheet in Excel and as such, can be formatted as a unit to change how they are displayed. Use the following articles about Excel's row formatting capabilities to make your columns appear just right.
The following articles are available for the 'Row Formatting' topic. Click the article's title (shown in bold) to see the associated article.
Adjusting Row Height for a Number of Worksheets
Adjusting the height of a row or range of rows is relatively easy in Excel. How do you adjust the height of those same rows on a number of different worksheets? Here's how!
Automatic Row Height For Merged Cells with Text Wrap
When you have text wrap turned on in a cell, Excel expands the height of the row as you add more text to the cell. When you merge two cells that have text wrap turned on, Excel won't adjust the row height to accommodate the text in the cell. This can, of course, cause problems. How you deal with this situation is described in this tip.
Automatic Row Height for Wrapped Text
When you format a cell so that the information within it can wrap to multiple lines, you may be surprised if Excel doesn't adjust the row height to display all those lines. Here's why this can happen and what you can do about it.
Detecting Hidden Rows
Excel allows you to easily hide rows in a worksheet, so their contents are not visible. Figuring out how to detect where those hidden rows can be a very manual process—unless you use some of the ideas in this tip.
Hiding and Unhiding Rows
When building a worksheet, you may need to hide some of the rows or unhide other, previously hidden, rows. It's easy to do; here's how.
Hiding Rows Based on Two Values
It's easy to use filtering to hide rows based on the value in a cell, but how do you hide rows based on the values in two cells? Here are a couple of ideas on how you can pare down your data.
Setting Row Height
When you enter information into a row on a worksheet, Excel automatically adjusts the height of the row based on what you enter. If you want to override the height that Excel chooses, apply one of the techniques described in this tip.