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.
Excel Wrap Text
Mitchell Morrison wrote on December 31, 1969 19:00 EST
I followed the instructions above. The wrap worked fine as long as I stayed in the same work book. When I opened another workbook the wrap text style was gone from the style box. How can I keep in the style box on every workbook?
Excel Wrap Text
Ruta wrote on December 31, 1969 19:00 EST
Agreed! How can we have this as a saved option for every new spreadsheet?
Excel Wrap Text
Wayne Lukehart wrote on December 31, 1969 19:00 EST
To ensure Excel Wrap, or any other Style box creation is saved for all future new worksheets:
1. open a new worksheet
2. make the changes to the StyleBox as suggested in the tip for Wrap Text.....one suggestion, change the Style Box wrap text function name to A_WrapText and it will show up as the first function in the style box if you use the wrap text function quite a bit
3. Do a File:SaveAs and at the bottom of the dialog box change the Save As Filetype to Template (*.xlt) and name the file to be saved Book
4. At the top of the dialog box, change the Save In: folder location to C:Program FilesMicrosoft OfficeOffice10XLStart
5. Now every time you select a new worksheet it will have the wrap text or any other sytle funciton customization that you have put into the sytle box prior to saving Book.xlt to the XLStart folder
Saving Wrap Text Style for a new worksheet
Wayne Lukehart wrote on December 31, 1969 19:00 EST
To ensure Excel Wrap, or any other Style box creation is saved for all future new worksheets:
1. open a new worksheet
2. make the changes to the StyleBox as suggested in the tip for Wrap Text.....one suggestion, change the Style Box wrap text function name to A_WrapText and it will show up as the first function in the style box if you use the wrap text function quite a bit
3. Do a File:SaveAs and at the bottom of the dialog box change the Save As Filetype to Template (*.xlt) and name the file to be saved Book
4. At the top of the dialog box, change the Save In: folder location to C:Program FilesMicrosoft OfficeOffice10XLStart
5. Now every time you select a new worksheet it will have the wrap text or any other sytle funciton customization that you have put into the sytle box prior to saving Book.xlt to the XLStart folder
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
Investing for Dummies, Third Edition
