How To Wrap Text In A Cell In Excel (Excel)

How To Wrap Text In A Cell In Excel (Excel)
How To Wrap Text In A Cell In Excel (Excel)

Video: How To Wrap Text In A Cell In Excel (Excel)

Video: How To Wrap Text In A Cell In Excel (Excel)
Video: 1 ( Excel) How to Wrap text Inside Excel 2024, November
Anonim

In Excel, by default, the text inside a cell is not wrapped and is printed on one line. It is not uncommon for table cells to contain a lot of text. Therefore, for better perception and compactness, it becomes necessary to place the contents of the cell not in one line, but in several.

How to wrap text in a cell in Excel (Excel)
How to wrap text in a cell in Excel (Excel)

In Excel, there are several options to transfer text within one cell at once.

1 way

You need to use the cell formatting tool.

Image
Image

1) Right-click on the desired cell or on several cells at once in which you want to wrap the text. In the context menu, select Format Cells.

Image
Image

2) A formatting window opens. You need to open the "Alignment" tab and in the "Display" block put a check mark on the "Wrap by words" item.

Image
Image

3) It remains to click on the "OK" button. The text will be wrapped and will be displayed not in one line, but in several.

Image
Image

2 way

1) Select the desired cell, for this, just click on it with the left mouse button.

2) On the toolbar of the Excel program, click on the "Wrap Text" button.

Image
Image

This method is much more convenient than the previous one, and less time is spent.

3 way

1) Switch to the text editing mode, to do this, double-click the left mouse button inside the cell. In this case, the cursor must be placed in front of the part of the text that you want to move.

Image
Image

2) Now type the "Alt" + "Enter" key combination on the keyboard. The text will be split.

Image
Image

3) To see the final result, just exit the cell editing mode.

Image
Image

To exit the editing mode, you can press the "Enter" key or click once with the left mouse button on any other cell of the table.

Recommended: