There are two ways in Excel to wrap your text in cells. One automatically and the other manually. Either way it is a great tool to allow more control over the look and feel of your labels and titles in Excel to really give your worksheets that edge.
I will take you through both methods – use which one you feel more comfortable with.
As usual it is way easier to use an example.
I have typed in cell A1 Yearly Sales Figures, when I pressed enter, it spills over to cell B1 and C1. To make this label look better and my spreadsheet more clear I can wrap the text into cell A1.
Automatic Method
Excel 2007
1. Highlight cell A1
2 Home tab
3. Wrap text on the ribbon
< Excel 2007
1. Format Cells
2. Alignment
3. Text control
4. Tick Wrap Text
Manual Method
Again I have typed Yearly Sales Figures into cell A1, this time to manually wrap the text in both < 2007 and Excel 2007
1. Type your text
2. In the formula bar place the cursor after the place where you want your work to wrap. In my example I want to word wrap after Sales
3. Pres CTRL + Enter
Job done.
Which method do you use most to word wrap? What is the quickest for you?.