Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell to wrap the text automatically or enter a manual line break. Wrap text automatically In a …

Format a cell so that text wraps automatically in an Excel spreadsheet. Text inside the cell wraps to fit the column width. When you change the column width, text wrapping adjusts automatically.

Wrap around straight edges To wrap text around a shape that has straight edges, such as a rectangle, insert WordArt objects for each edge. In this example, WordArt is inserted four …

Insert a line break to start a new line of text or add space between lines of text in a cell in Excel.

Insert a picture into your document. Select the picture. Select Layout Options . Select the layout you want: In Line with Text Square Tight Through Top and Bottom Behind Text In Front of …

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

Fix data that is cut off in cells by having the text wrap automatically, changing the alignment, decreasing the font size to fit data in a cell, or rotating the text so everything fits inside a cell.

Although Excel offers no direct control for line spacing within a cell, you can use several text alignment strategies to adjust white space or make the text more readable.

To prevent text from automatically wrapping to the next line when the user types more text than the width of the text box, clear the Wrap text check box. In the Scrolling list, click the text …

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.