Home » Resources » Excel 2007 Tutorial » Text Wrapping

The cells in a spreadsheet are quite small, so typing in a lot of information can lead to it overlapping and covering up other cells. One method for confining lots of information to just one cell block is text wrapping.

Try this out by typing a lot of text in to a cell so that is overlaps the edge. Next, select the cell by clicking on it, and then click on the Wrap text button in the ribbon above. After you have done this the text should be confined to the vertical cell borders, as seen below:

Similar resources you may like

1. Highlighting Cells
2. Submitting Information
3. Auto Sum
4. Customising Borders and Cell Size
5. Excel Functions

Tags

Excel, Excel 2007 Tutorial, excel training, excel tutorial, Free, microsoft, microsoft excel, microsoft office, spreadsheet, text wrapping, Tips, top Tips, training

Share This Resource

This entry was posted by Alistair Wylie on Friday, May 1st, 2009 at 5:09 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.