Adding a Wrap Text Shortcut in Microsoft Excel

Wrap text is a useful technique that you will use frequently when working in Excel.

You add the shortcut by adding a style in the Style box.

Adding the Style box to the Formatting toolbar:

  • Right-click one of the toolbars, and select Customize.
  • Select the Commands tab, and then select Format.
  • 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).
  • Click Close.

Adding wrap text to the Style box:

  • Enter text or several words into a cell in the worksheet, and press Ctrl+1.
  • Select the Alignment tab, check the wrap text check box, and click OK.
  • In the Style box, enter the text wrap text.

This Excel Tip is compliments of Exceltip.com