» Adding a Shortcut for Wrapping Text
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Special Edition Using Microsoft Outlook 2002
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Microsoft PowerPoint Version 2002 Step by Step
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Getting to Yes: Negotiating Agreement Without Giving In
- Accounting Principles, with CD, 6th Edition
Excel Wrap Text
Mitchell Morrison
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
Agreed! How can we have this as a saved option for every new spreadsheet?
Excel Wrap Text
Wayne Lukehart
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
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
