Welcome toExcel2007.Tips.Net
Beauty Tips
Cooking Tips
Health Tips
Wedding Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
It is fairly easy to put more text in a cell than can be readily displayed. While you can widen the column to fit your text, sometimes this is not a good (or viable) option. Instead, you can wrap the text within the cell, so that the cell height is increased to display all the text. Follow these steps:
It is important to remember that your row height will only increase automatically if you haven't explicitly specified the row height. If the height doesn't expand to fit the contents of the cell, follow these steps, after doing the previous steps:
The text should now be wrapped within the cell and all visible.
Related Tips:
Save Time! WordTips has been published weekly since early 1997. Past issues are available in convenient WordTips archives. Have your own enhanced archive of WordTips at your fingertips, available to use at any time! Check out WordTips Archives today!