Row Formatting

Tips, Tricks, and Answers

The following articles are available for the 'Row Formatting' topic. Click the article's title (shown in bold) to see the associated article.

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.

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 AutoFilter 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.