Wrapping Text in Excel

[trainer2000]

I have tried the following techniques to wrap text in excel. I have
followed them exactly as shown and in that order. The process works
fine in a workbook. When I move to another workbook the Wrap text style
is gone from the Style box. How can I make it stay permanently for all
workbooks?


Adding a Shortcut to Excel for Wrapping Text

Step 1: Adding the Style Box to the Formatting Toolbar:
1. Right-click one of the toolbars, and select Customize.
2. Select the Commands tab, and then select Format.
3. Drag the Style icon from the Customize dialog box to the Formatting
toolbar, and drop it next to the Font Size box (or anywhere else you
choose).
4. Click Close.

Step 2: Adding Wrapped Text to the Style Box:

1. Enter text into a cell in the sheet, and press Ctrl+1.
2. Select the Alignment tab, select the Wrap text checkbox, and click
OK.
3. In the Style box, enter the text WrapText.
4. To use the Wrap text shortcut, select a cell, and then select Wrap
text from the Style box.

 

[Dave Peterson]

If you use the existing workbook as the basis for the new workbook, then the
style will come with it.

But styles live in workbooks. You can create a template (book.xlt in your
XLStart folder) that contains this style. Then all new workbooks created by
clicking on the New icon will inherit this style.

But if you have an existing workbook without the style, you can open a workbook
with that style and merge them.

Format|style|Merge