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.