If Excel text is running over neighboring cells, choose Home > Wrap Text to display it on multiple lines, or widen the column; text normally overflows only when the cells to its right are empty. The text is still stored in its original cell—overflow is a display effect, not a change to the cell’s value.
How text overflow works
In Excel for Microsoft 365 on Windows, a cell can show more text than its column is wide by letting the visible text extend into the empty cell or cells beside it. For example, if A2 contains “Quarterly planning meeting” and B2 is empty, the words may appear across the boundary between columns A and B. Click A2 or look at the formula bar to confirm that the entire entry remains in A2.
When a neighboring cell contains something, Excel has nowhere to display the extra characters, so the visible text stops at the cell boundary. The entry itself is not shortened. If you clear the neighboring cell, the text may appear to run across it again. A cell that looks empty can still block overflow if it contains a space or a formula that returns an empty string; its displayed appearance does not necessarily mean the cell is truly blank.
Overflow depends on the cell’s formatting and the available space. It is different from a formula error, a change in the underlying value, or Excel’s dynamic-array spill feature. Understanding which behavior you are seeing helps you choose the right fix.
Stop overflow with Wrap Text
Wrap Text keeps the column width and displays long entries on two or more lines within the same cell. This is often the clearest option for headings, notes, and descriptions when you want to preserve a compact table layout.
- Select the cell or range containing the text.
- On the Home tab, select Wrap Text in the Alignment group.
- If the full text is not visible, adjust the row height. Choose Home > Format > AutoFit Row Height, or drag the row boundary to make the row taller.
To wrap several entries, select the whole range before turning on the setting. You can also select an entire column by clicking its letter. Wrapping changes how content is displayed, not what is stored, so copying the cell or reading its value still gives you the complete text.
In Excel for Mac, select the cells and use Home > Wrap Text; the ribbon command is comparable. Excel for the web also provides Wrap Text on the Home tab. Ribbon arrangement can vary slightly with window size, but the command remains in the alignment controls.
Show the text by changing column width
If you want a single-line entry, widening the column is usually the most straightforward solution. Point to the right edge of the column letter at the top of the sheet and drag it to the right. To fit the widest visible entry automatically, double-click that edge. You can also select the column and choose Home > Format > AutoFit Column Width.
AutoFit measures the contents in the selected column and adjusts its width to accommodate the widest entry. That can be useful for a small list, but one unusually long note can make the column much wider than the rest of the worksheet. Consider selecting a group of columns or setting a consistent width instead if a broad table needs a uniform appearance.
Column width is shared by every cell in that column. Widening it to reveal one label also affects the other rows and can make a printed sheet span more pages. If the text is important but the table must stay narrow, wrapping is generally a better choice.
Use Shrink to Fit or clip the display
Shrink to Fit reduces the displayed font size enough to fit the cell’s contents on one line within its existing width. Select the cells, open the Format Cells dialog, choose the Alignment tab, and select Shrink to fit. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 opens the corresponding dialog. The option is useful for short labels in fixed-width columns, but a long sentence can become too small to read.
Shrink to Fit does not shorten the text or permanently change the font size you chose. It scales the text’s display to fit the cell. If the column width changes, the displayed size may change as well. Check the worksheet at its intended viewing or print size before using this approach across a report.
Clipping is another possible result: the cell shows only the characters that fit, with no continuation into the next cell. This commonly happens when the cell to the right contains data. Clipping can be appropriate when only the first part of a label matters visually, but it can hide meaningful information. Do not assume that a truncated-looking entry has been deleted; select the cell or inspect the formula bar to see its full contents.
Choose the right display option
The best fix depends on whether you value readability, a compact layout, or a single-line view. Use these general guidelines:
- Wrap Text: Choose it for descriptions, notes, and headings that should remain readable inside a narrow column.
- Widen the column: Choose it when a single-line value matters and the extra width will not disrupt the rest of the sheet.
- AutoFit: Choose it for quick sizing when the longest entry will not create an impractically wide column.
- Shrink to Fit: Choose it for short, fixed-width labels where a modest reduction in displayed type is acceptable.
- Leave overflow visible: Choose it when adjacent cells are empty and the overflow does not obscure other information.
For example, a column of product descriptions is usually easier to read with wrapping and a suitable row height. A short heading such as “Net sales” might fit after a small width adjustment. Shrinking an entire paragraph into a narrow cell may technically reveal it, but it is unlikely to be a helpful presentation.
Common causes of confusing results
If Wrap Text is enabled but some words still seem missing, first check the row height. A fixed row height can hide wrapped lines below the visible portion of the cell. Use Home > Format > AutoFit Row Height, or increase the row height manually. If the cell is part of a merged range, automatic row sizing may not behave as expected; unmerge it if appropriate, or adjust the row height manually.
Also check whether text is actually in the cell you think it is. A long entry can appear to sit across several columns while being stored only in the first one. Select the apparent starting cell and inspect the formula bar. Conversely, a value in a neighboring cell—even one that looks blank because a formula returns an empty string—can stop the visual overflow.
Numbers and dates can produce a different display problem. A narrow column may show hash marks such as #### rather than text extending into the next cell. This usually means the column is too narrow to display the formatted number or date, although hash marks can have other causes in some contexts. Widen the column or change the number format; Wrap Text is not generally the fix for a numeric value displayed as hash marks.
Finally, distinguish ordinary text overflow from a dynamic-array spill. A spill occurs when a formula returns multiple results into neighboring cells; if those destination cells are blocked, Excel can report a #SPILL! error. That is a formula-output issue, not a long text entry merely crossing a cell boundary. Clear or move the blocking content if the formula’s results need room to spill.
Keep the worksheet readable when printing
A sheet that looks fine on screen may print differently because page scaling, paper size, and print area affect the available space. Widening columns can push a worksheet onto additional pages, while scaling the entire sheet to one page can make text too small. Before printing, use File > Print to preview the result and check whether wrapped rows are tall enough and column headings remain legible.
If a table needs to fit a page, consider adjusting margins or page orientation before shrinking all content. You can also set a print area around the relevant data. These choices affect the printed layout, not the underlying cell contents, and may be more useful than forcing every long entry into a narrow column.
Frequently Asked Questions
Why is Excel text showing over the next cell?
Excel displays text beyond a cell’s edge when it does not fit and the adjacent cell is empty. The extra characters remain part of the original cell’s value. Add content to the adjacent cell, wrap the text, or change the column width to alter the display.
How do I keep text inside one cell?
Select the cell and choose Home > Wrap Text. Excel will show the entry on multiple lines within the cell, though you may need to increase or autofit the row height so every line is visible.
Does overflow mean Excel deleted part of my text?
No. Overflow and clipping affect what is visible, not the stored entry. Select the cell and check the formula bar to review the full text. A cell that appears cut off can still contain all its characters.
Why does a blank-looking cell stop text from overflowing?
It may contain a space, another invisible character, or a formula that displays an empty string. Select the neighboring cell and inspect the formula bar or clear its contents if you have confirmed that it should be empty.
Why do I see #### instead of the text?
Hash marks commonly indicate that a number or date does not fit its current column width or number format. Widen the column or choose a more compact number format. This is different from ordinary text overflow.
Can I make the text appear smaller without changing the column?
Yes. In Format Cells, open Alignment and select Shrink to fit. It reduces the displayed text size to fit the cell, but very long entries can become difficult to read; wrapping or widening the column may be better.
Related
- Data Validation Interview Questions and Strong Answers
- Data Validation Greyed Out in Excel? Causes and Fixes
- Excel Data Validation Guidelines for Reliable Spreadsheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Import Archive Emails in Outlook: Full GuideTo import archived emails into Outlook for Windows, open classic Outlook and choose File > Open & Export…
- 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…
- Excel Row and Column AutoFit: Steps, Limits, and FixesTo auto-adjust Excel row or column size, select the relevant rows or columns, then choose Home > Cells…
- Merge Columns in Google Sheets: Methods, Tips, and FixesTo join the text or values in two Google Sheets columns, enter a formula such as =A2&" "&B2…
- Excel Freeze Panes: How to Lock Rows and Columns in PlaceYes. In Excel for Microsoft 365 on Windows, you can freeze rows and columns at the same time:…
- Conditional Formatting in Spreadsheets: How It WorksConditional formatting in a spreadsheet automatically changes a cell’s appearance when its value meets a condition; in Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.