In Excel, text usually spills into the cell to its right when that cell is empty; if the neighboring cell contains anything, the text is clipped. To keep all the text inside its own cell, select the cell and choose Home > Wrap Text, or widen the column with Home > Format > AutoFit Column Width.
Why text appears to go out of a cell
Excel stores a cell’s value separately from the space available to display it. A long text entry can therefore remain intact even when the column is too narrow to show all of it. By default, text is generally aligned to the left, and Excel lets it appear across the next cell if that cell is empty. This visual spill does not move the text or change the contents of either cell.
When the cell immediately to the right is not empty, Excel cannot display the spill across it, so the text appears cut off at the column boundary. The neighboring content might be obvious, such as a name, or easy to overlook, such as a space, a formula, or a value formatted so it is hard to see. A formula that returns an empty-looking result can also make a cell behave differently from a truly empty cell.
Text that looks cut off is not necessarily deleted. Click the cell and check the formula bar above the worksheet to see the complete entry. If the full text appears there, the issue is display or layout, not lost data. This distinction matters before editing: replacing the cell contents just to make them visible could erase information that is already present.
Quick fixes: wrap the text or widen the column
Use Wrap Text when you want a fixed column width and are comfortable with the row becoming taller. Select one or more cells, then choose Home > Wrap Text. Excel displays the contents on multiple lines within each cell and adjusts row height to show the wrapped lines in many ordinary layouts. You can select a whole column or range before turning the setting on.
Use AutoFit Column Width when the text should remain on one line and there is room to make the column wider. Select the column, then choose Home > Format > AutoFit Column Width. For a quick manual adjustment, point to the boundary on the right side of the column letter at the top of the sheet and drag it. Double-clicking that boundary fits the column to its contents.
These are different solutions, not two names for the same setting. Wrapping preserves the column width and adds lines; widening preserves a single line but takes space from the rest of the worksheet. For a label column beside several narrow data columns, wrapping may keep the table compact. For a short heading that is only a little too long, widening can be simpler.
- Choose Wrap Text for descriptions, comments, or addresses in a table with a planned column width.
- Choose AutoFit Column Width for a worksheet where readability matters more than keeping columns a uniform size.
- Drag the column boundary when AutoFit makes the column excessively wide because one entry is unusually long.
How Wrap Text affects rows and cells
Wrapping breaks text onto additional display lines at spaces where possible, while keeping the underlying entry in one cell. It is useful for multiword text, but it can make rows taller and the worksheet harder to scan if many cells contain long paragraphs. If the row height has been set to a fixed value, some wrapped lines may remain hidden. Select the row and use Home > Format > AutoFit Row Height, or drag the lower boundary of the row number to increase its height.
Line breaks entered inside a cell are different from automatic wrapping. A manual line break stays at the position where it was inserted, while automatic wrapping changes as the column width changes. On Windows, press Alt+Enter while editing a cell to insert a line break. On Mac, use Control+Option+Return in many current Excel configurations; keyboard behavior can vary with the Mac and Excel version, so the Insert Line Break command in the editing context is another option when available.
Merged cells need special attention. Excel may not automatically calculate row height correctly for wrapped text in a merged range. If a merged heading still looks clipped after Wrap Text is enabled, unmerge it if practical, or adjust the row height manually. Merged cells can also make sorting, filtering, and selecting data more awkward, so they are usually best reserved for presentation headings rather than regular table data.
When widening the column is not the best answer
AutoFit sizes a column according to the contents it needs to accommodate, so a single very long entry can make the entire column too wide. That can push related columns off-screen or make a printed sheet span more pages. Instead of accepting an awkward result, consider wrapping the long entry, increasing the width by a smaller amount, or using a shorter display label while preserving the full description elsewhere.
AutoFit is also not always a good match for a carefully designed report. Uniform column widths may be important for comparison, or the worksheet may need to fit on a printed page. In those cases, set a deliberate width by dragging the column boundary or use Home > Format > Column Width to enter a value. Then turn on Wrap Text for cells that need additional vertical space.
For a large selection, remember that one long value can determine the fitted width for the entire column. If the result seems unexpectedly large, inspect the longest entries before changing the layout. You can also AutoFit only selected columns rather than the whole worksheet, which avoids changing the widths of unrelated data.
Shrink to Fit and other alignment settings
Shrink to Fit is an alternative when the cell must stay on one line and its column cannot grow. Select the cells, open Format Cells, 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 text remains in the cell, but Excel reduces its displayed size to fit the available width. Long entries may become difficult to read, especially when the cell is very narrow.
Shrink to Fit does not shorten the stored text, and it is not the same as reducing the font size manually. It is most suitable for occasional headings or short labels where a small change in displayed size is acceptable. For paragraphs or content that people need to read comfortably, wrapping is usually clearer. The alignment options in Format Cells can also control horizontal and vertical placement, but changing alignment alone does not create more room for the text.
Text overflow versus #### and other display problems
Not every cell that looks wrong has a text-overflow problem. Excel commonly displays a series of number signs, such as ####, when a column is too narrow to show a numeric value or date in its current format. Widening the column often resolves that. For some date or time calculations, #### can also indicate a negative date or time result that the selected date system cannot display. Check the formula and number format rather than applying Wrap Text to a numeric cell.
Numbers and dates are generally right-aligned by default, while text is generally left-aligned. A long numeric value might be rounded or shown in scientific notation depending on the column width and number format, rather than spilling across empty cells like ordinary text. If an identifier such as 001234 must retain its leading zeros, it may need a text format or a custom number format; changing the width alone does not restore zeros that were already removed during entry.
A formula can return text, a number, a date-like value, or an empty-looking result. Its display follows the result and the cell’s formatting, not merely the fact that the cell contains a formula. If a formula result looks clipped, check the formula bar, the adjacent cell, the number format, and the alignment. This helps separate a width issue from a formula or formatting issue.
Check for hidden content and layout constraints
If Wrap Text or AutoFit does not appear to solve the issue, check the following before changing the data:
- Click the cell and read the formula bar to confirm the complete text is still present.
- Check the cell immediately to the right for a value, formula, or even a space that prevents visible spillover.
- Look for a fixed row height that could hide wrapped lines.
- Check whether the cell is part of a merged range, where automatic row sizing may not behave as expected.
- Confirm the cell is not showing #### because it contains a number or date in a narrow column.
- Inspect the alignment and number format if the visible result differs from what the cell should contain.
Another common misconception is that text spilling into a blank neighboring cell means the text has been divided between two cells. It has not: the value remains in its original cell. Conversely, text that is cut off at a boundary may still be complete even though the worksheet view does not show it. Use the formula bar or edit the cell to verify before copying, deleting, or retyping anything.
Keep the worksheet readable on screen and in print
A layout that works on screen may not work on paper. Wrapped text can increase row heights, while a widened column can make the printed worksheet span extra pages. Before printing, use File > Print to review the preview. If the sheet is too wide, consider using landscape orientation, adjusting margins, or scaling the printout; excessive scaling can make text too small to read. Print settings affect the page output, not the underlying cell contents.
For shared workbooks, consistent layout choices make a difference. A table with fixed-width columns and wrapped descriptions is often easier to compare than one where every column expands to fit its longest entry. A one-off report may benefit from AutoFit instead. Choose based on how readers will use the sheet: scanning rows, editing values, presenting a summary, or printing a copy.
Frequently Asked Questions
Why does Excel text go into the next cell?
Excel displays left-aligned text beyond its cell when the adjacent cell is empty and there is enough space. The text remains stored in the original cell; it is only its on-screen display that extends into the neighboring area.
How do I stop text from spilling into another cell?
Select the cell or range and choose Home > Wrap Text. You can also widen the column so the full entry fits on one line, or use Shrink to Fit if the column width must stay fixed and smaller text remains readable.
Why is Excel cutting off text even though the next cell looks blank?
The neighboring cell may contain a space, a formula, or another value that is not visually obvious. Check it by selecting it and looking at the formula bar. A fixed row height can also hide lines when Wrap Text is on.
Does text going out of a cell mean I have lost part of it?
Usually not. Select the cell and inspect the formula bar; it shows the full contents even when the worksheet display is clipped. If the complete entry is there, adjust the layout rather than replacing the value.
Why does a cell show #### instead of overflowing?
That usually means Excel cannot display a number or date in the available width or format. Widen the column and check the number format. For date or time calculations, also check whether the result is negative.
Choosing the right fix
For ordinary text that spills or is cut off, start by confirming the full entry in the formula bar. Use Wrap Text when the column should stay a set width, AutoFit or manual widening when a single line is preferable, and Shrink to Fit only when limited space matters more than consistent text size. If you see #### or wrapped lines remain hidden, investigate the number format, row height, or merged cells. These checks address the display problem without changing or deleting the stored text.
Related
- Power Query Remove Leading Zeros Without Losing IDs
- Power Query Reference: What It Does and When to Use It
- Excel Data Validation: Can You Select Multiple Items?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Why Is My Excel Filter Not Working? Causes and FixesAn Excel filter usually fails because the selected range is incomplete, the data has blank or merged headers,…
- Excel LAMBDA #VALUE! Error: Causes and FixesAn Excel LAMBDA #VALUE! error usually means the LAMBDA function was called with the wrong number of arguments,…
- VLOOKUP Not Working? Common Excel Causes and FixesVLOOKUP usually fails because the lookup value and the first column of the search range do not match…
- VLOOKUP Not Working Across Workbooks? Fix Common ErrorsVLOOKUP can search a range in another workbook, even when that workbook is closed, as long as the…
- Excel Dropdown Lists: Create, Edit, and Fix ThemTo make a dropdown list in Excel for Microsoft 365 on Windows, select the cells, choose Data >…
- Excel Set Print Area Not Working? Fix the Common CausesIf Excel’s print area is not working, select the intended cells and choose Page Layout > Print Area…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.