To wrap text inside an Excel text box, select the text box, open Format Shape, choose Text Options > Text Box, and turn on Wrap text in shape. The words will then flow onto additional lines within the box instead of extending in one long line; you can adjust the box width and height to control how the text appears.
Turn on wrapping in an Excel text box
In Excel for Microsoft 365 on Windows, create a text box from Insert > Text Box, then drag on the worksheet to draw it. To change an existing one, click its outside border so the whole object is selected. Right-click the border and choose Format Shape. In the formatting pane, select Text Options (the text-related icon), open Text Box, and check Wrap text in shape.
If the text box is already selected, you can also open the contextual Shape Format tab and use the formatting controls to open the Format Shape pane. The right-click route is usually the most direct. Make sure you select the text box border rather than place the insertion cursor inside the text; otherwise, you may see text-editing options instead of controls for the object.
- To wrap: enable Wrap text in shape.
- To make lines shorter: drag a side handle inward to narrow the box.
- To show more lines: drag a top or bottom handle to change its height.
After changing the setting, click outside the pane or the text box to see the result. Wrapping changes the layout of the text, not the wording, and it does not change any cells underneath the object.
What wrapping does—and what it does not do
A text box is a drawing object that sits on top of the worksheet grid. Wrapping tells Excel to arrange the text on multiple lines within the object’s available width. For example, a sentence that appears on one line in a wide box may become three lines if you narrow the box. The height needed to display the sentence will increase as the line count increases.
Wrapping is not the same as making a worksheet column wider, nor is it the same as the cell setting called Wrap Text. Those controls apply to different objects. A cell’s content belongs to the grid and can affect row height; a text box is an independent shape that can be moved and resized over cells. Changing a column width does not automatically resize a text box or reflow its contents according to the new column boundary.
Wrapping also does not guarantee that every character will be visible. If the box is too short, lower lines may be clipped or the text may appear crowded, depending on the object’s autofit setting. A useful result requires both a suitable width and enough height, or an autofit choice that adjusts the shape or text.
Control the box size and text fit
Wrapping and autofit work together, but they are separate settings. Wrapping determines whether text can flow onto more lines. Autofit determines what Excel does when the text does not fit the shape’s available space. In the Format Shape pane, look under Text Options > Text Box for the autofit choices available in your version of Excel.
- Do not Autofit: the shape stays the size you set. If the contents need more room, text can be cut off or otherwise fail to display as intended.
- Shrink text on overflow: Excel reduces the font size so the text can fit inside the existing shape. This can preserve the box dimensions, but may make the text too small to read.
- Resize shape to fit text: Excel adjusts the shape to accommodate its text. This can prevent clipping, but the box may grow and cover nearby worksheet content.
For a dashboard label or callout, a fixed-size box with wrapping can keep the design aligned, provided you leave enough height for the expected text. For a note whose contents may vary, resizing the shape to fit can be more convenient. If the text box must remain within a particular area, avoid relying on automatic growth without checking the final layout.
Text boxes also have internal margins between their border and text. If a box seems to wrap earlier than expected, inspect the text box margins in the same formatting area and reduce them modestly if appropriate. Margins are useful for readability, so setting them to zero is not always an improvement. A small amount of inset space often makes a label look less cramped.
Use line breaks and format the text
Automatic wrapping is useful when Excel should decide where lines break based on the box width. For a label, address, or short callout where you want a deliberate line arrangement, put the cursor in the text and insert a paragraph break at the desired point. In a text box, pressing Enter while editing creates a new paragraph. You can combine these manual breaks with wrapping: the manual break fixes a chosen separation, while the remaining text still wraps as the box width requires.
For example, a small callout could place a heading on its own line and let a longer explanation wrap beneath it. Select only the heading text to apply a different font size or bold style, rather than changing the entire box. The Home tab’s font controls can format selected text in a text box, just as they can format selected worksheet text. Keep body text large enough to read at the worksheet’s normal zoom level; shrinking the view can make a well-formatted label look deceptively tiny.
When changing the width after adding manual line breaks, check the whole paragraph. A narrower box can add extra automatic lines, while a wider box may leave the manual break in place and create an unexpectedly short line. Use manual breaks for intentional structure, not as a substitute for setting a sensible box width.
Fix common text box wrapping problems
If wrapping appears not to work, first confirm that the selected object is actually a text box or another shape containing text. Then check the Wrap text in shape box in the Format Shape pane. A text box may look like a cell or a borderless label when its outline is hidden, so clicking near the text can sometimes select a cell underneath instead. Click around the text until selection handles appear around the object.
- Text runs past the right edge: verify that Wrap text in shape is enabled. Also check for a very wide text box, which may not need to wrap at its current size.
- Text wraps but the last lines are missing: increase the box height or choose an autofit option that suits the layout. A narrow box can create more lines than its height can show.
- Text becomes very small: check whether Shrink text on overflow is selected. Turn it off or enlarge the box if preserving the intended font size matters more than keeping a fixed shape.
- Words break in an awkward place: widen the box slightly, review long unbroken strings such as web addresses, and consider inserting a deliberate break in a suitable location.
- Text seems too close to the border: adjust the internal margins rather than adding spaces at the start of each line. Leading spaces are not a reliable layout method.
For long URLs, tracking codes, or other strings without spaces, wrapping may not produce the same natural word breaks as ordinary sentences. If a particular label must remain readable, widen the box, shorten the displayed wording, or place the string on a separate line. Avoid adding repeated spaces to force a visual layout: font changes and resizing can shift them unpredictably.
Text box wrapping versus cell Wrap Text
Choose a text box when the text is a free-standing annotation, title, instruction, or callout that should sit independently over the worksheet. It can be positioned over multiple cells without changing the worksheet’s row and column structure. This is useful for a chart note or a dashboard heading, especially when the object needs to move as one unit.
Choose a cell and the Home > Wrap Text command when the content is part of the table or data itself. Cell wrapping keeps the value in the grid, and Excel may increase the row height to show multiple lines. It is generally the better option for comments that belong to a specific record, such as a long product description in a table. In contrast, a text box can overlap cells and does not become part of a cell’s value.
A common misconception is that enabling Wrap Text on the Home tab will wrap text in a selected text box. That command is for cells. For a shape or text box, use the Format Shape pane’s text-box options. Conversely, changing Wrap text in shape does not turn on wrapping for any worksheet cells behind the shape.
Choose a useful layout before adding lots of text
The best dimensions depend on what the text box is for. A short label may need only a little height, while a multi-sentence explanation needs enough width to avoid a column of single words and enough height to show the result. A very narrow box technically wraps, but can be difficult to read because it creates many short lines. A very wide one may look like a sentence laid across the worksheet without a clear connection to the data.
Before finalizing a layout, consider these practical factors:
- Purpose: use a short text box for a title or callout and a cell for information that belongs in a structured row.
- Expected text length: leave room for the longest likely label, not only the shortest example.
- Worksheet zoom and printing: inspect the object at a normal viewing size and use Print Preview if the sheet will be printed.
- Nearby content: make sure a taller box will not obscure important cells, chart labels, or controls.
If the text changes often, test the layout with a longer realistic example before distributing the workbook. A short sample may fit perfectly while a later revision creates extra wrapped lines and hides the final sentence. For a visual report, consistency between related boxes—matching widths, margins, and font sizes—usually matters more than squeezing every word into the smallest possible area.
Excel for Mac and Excel for the web
Excel for Mac has similar shape-formatting controls, but the ribbon and pane layout can differ slightly from Windows. Select the text box, open its formatting pane or use the contextual shape-formatting tab, then look under the text options for the text box settings and the wrap control. If a command is not in the same place, use the shape’s formatting pane rather than the cell’s Home tab Wrap Text command.
Excel for the web can support common workbook editing, but available shape-formatting controls may differ from the desktop application and can change over time. If the web interface does not expose the wrap or autofit setting you need, open the workbook in the desktop version of Excel and change the text box there. The setting is part of the workbook’s object formatting, so desktop editing is also a sensible choice for a layout that needs precise control.
Frequently Asked Questions
How do I wrap text in an Excel text box?
Select the text box border, choose Format Shape > Text Options > Text Box, and enable Wrap text in shape. Resize the box if the new lines do not all fit.
Why is Wrap Text on the Home tab not working on my text box?
The Home tab’s Wrap Text command applies to worksheet cells, not drawing objects. Use the Format Shape pane’s text-box settings for text inside a text box.
Can Excel automatically make a text box taller?
Look in Format Shape > Text Options > Text Box for the autofit options. Resize shape to fit text can grow the object to accommodate its contents; the exact available controls can vary by Excel version.
Can I make a new line without changing the text box width?
Yes. Edit the text and press Enter where you want a paragraph break. Excel will keep wrapping the rest of the text according to the box width.
Does text box wrapping change the cells underneath it?
No. A text box is a separate object positioned over the worksheet. Its wrapping does not change cell values, column widths, or the cell Wrap Text setting.
Related
- Excel Data Validation Lists: Create and Manage Dropdowns
- Excel Shuffle List of Names: 10 Easy Methods
- Excel: Find Where a Cell Is Used Across Sheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Goal Seek for Multiple Cells: How Solver WorksExcel’s Goal Seek can change only one input cell at a time. To make Excel adjust multiple cells…
- Protect a Sheet in Excel: Steps, Options, and LimitsIn Excel for Microsoft 365 on Windows, protect a sheet by opening the worksheet, choosing Review > Protect…
- Excel Freeze Panes Glitching? Causes and FixesIf Excel Freeze Panes is glitching, first go to View > Freeze Panes > Unfreeze Panes, then select…
- Excel Shortcut Keys to Highlight Cells to the End of DataIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+End to select from the active cell through the worksheet’s…
- Google Sheets: Count Cells Containing Text?Yes. In Google Sheets, use =COUNTIF(A2:A100,"*") to count cells containing text in the range A2:A100. If you want…
- Google Sheets Dropdown From a Table: How It WorksYes. In Google Sheets, create a dropdown from table data by selecting the cells that need the menu,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.