How to wrap text in Excel

In Excel, we need to distinguish between automatic line wrapping and mixed graphic and text arrangement. 1. To make cell text wrap automatically, right-click the cell and right-click the "Set Cell Format" after clicking the cell, tick "Bring" in the "Alignment" tab, or directly click the "Bring" button in the toolbar. Excel will automatically adjust the line wrap position according to the cell width; 2. To arrange the text around the picture, you can insert the picture and right-click to select "Size and Properties", set "Move and Resize as the cell changes" in the "Properties" option, and then simulate the wrapping effect by manually adjusting the cells, merging areas, or using text boxes; 3. Other related techniques include trying "reducing font fill", "merging cells", using Alt Enter to manually wrap the lines, and using the "Auto Adjust Row Height" function to improve layout flexibility. These methods are suitable for different versions of Excel, and the core logic is consistent. When actually operating, you should first confirm whether the correct settings are enabled.

It is not difficult to implement text surround in Excel. The key is to find the correct setting position and understand its usage scenario. If you want the content in the cell to be automatically wrapped, adapt to the cell width, or arrange the text around the inserted image, you need different operations. The following are explained separately.

How to make cell text wrap automatically

This is the most common "text wrapping" requirement, especially when there is a lot of cell content, and you want it to wrap it automatically instead of expanding it horizontally.

• Click the target cell, right-click to select "Format Cell", switch to the "Align" tab, and check "Bring Auto Lines".
• Or just click the "Bring" button in the toolbar (usually displayed as a bent arrow icon).
• After the settings are completed, Excel will automatically adjust the line break position according to the cell width. You can also manually adjust the row height or column width to optimize the display effect.

Note: Automatic line wrapping is only applicable to the content of the current cell and will not affect the layout of surrounding cells.

How to arrange text around pictures or objects

If you want to insert a picture and arrange the surrounding text around it like a document, Excel's default function does not support this "graphic and text mixing". But you can use some techniques to simulate similar effects:

• After inserting the picture, right-click to select "Size and Properties".
• In the Properties option, set Position to Move and resize as the cell changes.
• Next, you may need to manually adjust the cell size, merge areas, and even use text boxes to place text to achieve visual "walking".

Although it cannot be freely typed like Word, this method can also meet some display needs when the table structure allows.

Other related tips

Sometimes you think it is a problem with "text surround", but in fact, other settings are not adjusted properly:

• If the content is too long, the latter cells are incomplete, try "Shrink Font Fill" or "Merge Cells".
• Using Alt Enter allows you to manually wrap lines at a specified location, which is more flexible than automatic wrapping.
• For line height adaptation after automatic line wrapping, you can double-click the boundary under line number, or use "Format → Automatically adjust line height" in the "Start" menu.

These details are often overlooked but are very practical when dealing with complex table content.

Basically these are the methods. The interfaces of different versions of Excel may vary slightly, but the core logic is the same. When encountering problems, you can first confirm whether the "automatic wrapping" is not turned on, or that non-native functions such as image wrapping are misused.

The above is the detailed content of How to wrap text in Excel. For more information, please follow other related articles on the PHP Chinese website!