Text Wrapping In Excel


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?.

More Text Information For Excel.

1. Using the Left function

2. Using the Right function

3. The handy Concatenate function in Excel

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts