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 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:
1. Select the cells whose formatting you want to affect.
2. Press Ctrl+Shift+F. Excel displays the Format Cells dialog box.
3. Click on the Alignment tab.
4. Make sure the Wrap Text check box is selected.
5. Click on OK.
The text should now be wrapped within the cell and all visible.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment