Excel Hack

Wrap text in Excel shortcut

If you enter a string of text that exceeds the width of a cell in Excel, the text will overflow into the adjacent cell. If the data exceeds the cell width, the cell can be wrapped to fit the length of the data. Most people perform this operation with the mouse, but shortcuts can be used to improve work efficiency. Here are some shortcuts for string wrapping.

Shortcut for wrapping text

Wrap text by cell width

Windows
Access Key: Alt + H + W

Mac
None

Set in the Format Cells dialog box

Windows
Ctrl + 1

Mac
command + 1 or control + 1

Wrap text at the cursor position in a cell

Windows
Alt + Enter

Mac
control + option + return

Wrap text by cell width

For information on how to use wrapped text with shortcuts, see below.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell in which you want to wrap text.

Wrap text by cell width

Wrap text by cell width

Press Alt + H + W. Text now wraps around the width of the selected cell.

Set in the Format Cells dialog box

Select a cell

Select the cell in which you want to wrap text.

Open the Format Cells dialog box

Press Ctrl + 1. The Format Cells dialog box appears.

Place a check mark in Wrap text

Press A. Select the Alignment tab.

Press Alt + W and check the Wrap text checkbox.

Wrap text

Press Enter. Text now wraps around the width of the selected cell.

Wrap text at the cursor position in a cell

Select a cell

Select the cell in which you want to wrap text.

Cursor in a cell

Press the F2. Place the cursor in the cell.

Move the cursor in a cell

Press (Left Arrow key) several times to position the cursor where you want the text to wrap.

Wrap text

Press Alt + Enter. The text has been wrapped at the cursor position.

Completion of text wrapping

Press Ctrl + Enter. Wrapping of the text in the selected cell is now complete.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments