Adding a Shortcut for Wrapping Text

Using keyboard shortcuts

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.
Screenshot // Adding a Shortcut for Wrapping Text
Adding a Shortcut for Wrapping Text

Comments

  1. Drag the Cells icon up to your task bar instead of the Style box. All you will have to do is click on the icon and click on the wrap text. If you leave it little Format cells window on alignment when you close it, it will be available to you with only 2 clicks. Once on the icon and then on "wrap text". Of course you can use this shortcut with any cell formating you need to do.

  2. "I can get it to work (e.g. it ""saves"" my style), but then it's to ""complicated"" to use the style.

    Here's two ways of doing it without using the mouse:

    1. Press Ctrl+1 and the use the Alt+? (the ? has to be replaced by the correct character - it's M in my Danish version of Excel).
    2. Create a Macro that set the wrap text and assign to a key (e.g. Ctrl+W)

    Hope this helps.

    /h.c.andersen"

  3. "Same result as dr mom - cd type ""wrap text"" into the style box, but it disappears.
    Could not find this topic in Excel Help, either"

  4. "I was hoping for a single clip shortcut.
    It still takes me 4 clicks to add wrapping as a style.
    I have to compare this with using the format=>cells=>alignment command which takes me 5 clicks (or 4 if the tab is already on alignment).
    Have I misunderstood?"

  5. I couldn't get this to work. I could enter the text,"wrap text" into the style box, but it would disappear if I moved to another cell.

  6. Drag the Cells icon up to your task bar instead of the Style box. All you will have to do is click on the icon and click on the wrap text. If you leave it little Format cells window on alignment when you close it, it will be available to you with only 2 clicks. Once on the icon and then on "wrap text". Of course you can use this shortcut with any cell formating you need to do.

  7. "I can get it to work (e.g. it ""saves"" my style), but then it's to ""complicated"" to use the style.

    Here's two ways of doing it without using the mouse:

    1. Press Ctrl+1 and the use the Alt+? (the ? has to be replaced by the correct character - it's M in my Danish version of Excel).
    2. Create a Macro that set the wrap text and assign to a key (e.g. Ctrl+W)

    Hope this helps.

    /h.c.andersen"

  8. "Same result as dr mom - cd type ""wrap text"" into the style box, but it disappears.
    Could not find this topic in Excel Help, either"

  9. "I was hoping for a single clip shortcut.
    It still takes me 4 clicks to add wrapping as a style.
    I have to compare this with using the format=>cells=>alignment command which takes me 5 clicks (or 4 if the tab is already on alignment).
    Have I misunderstood?"

  10. I couldn't get this to work. I could enter the text,"wrap text" into the style box, but it would disappear if I moved to another cell.

Leave a Reply

Your email address will not be published. Required fields are marked *

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.