Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Hiding and Unhiding Rows Excel allows you to hide rows from sight. Just select the rows and choose Format | Row | Hide, and they are gone. This tip discusses not only hiding rows, but how to again display them. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Hiding Rows Based on Two Values A common task in accounting (and other areas) is to suppress the display of tables in a row based on whether the values in two cells of a row meet a particular criteria. This tip explains some easy ways you can check those cells and modify the visibility of the row accordingly. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Setting Row Height You can adjust the height of each row in an Excel worksheet. There are two ways you can easily adjust the row height, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)