Excel Text Getting Cut Off? Causes, Fixes, and Tips

How-to basics · Updated November 18, 2026

If Excel text is getting cut off, widen the column or turn on Home > Alignment > Wrap Text. Text that disappears at a cell edge is usually still stored in the cell; the column, neighboring content, row height, or formatting is preventing it from being displayed fully.

Why Excel text appears cut off

Excel normally lets text overflow into the next cell when that cell is empty. If the next cell contains anything, even a space or a formula that returns an empty-looking result, the text cannot spill across it and appears clipped at the column boundary. The value in the original cell is not necessarily shortened: select it and check the formula bar to see what Excel has stored.

Other causes include a column that is too narrow, a row with a fixed height, text wrapping that needs more vertical space, or an alignment setting such as Shrink to fit. Merged cells can also complicate sizing. These causes can look alike on the worksheet, so first identify whether you are seeing text, numbers, or a display problem in a particular layout.

  • Text stops at a cell edge: check the column width and whether the adjacent cell contains content.
  • Text appears on multiple lines but is still clipped vertically: check the row height.
  • A number or date shows hash marks: widen the column or check its number format.
  • Only part of a long entry is visible in the grid: inspect the formula bar; very long cell entries have a separate display limit.

Quick fixes to try first

For a single column, move the pointer to the right edge of its column letter heading and drag the boundary to the right. To size the column to its contents, double-click that boundary. You can also select the column and choose Home > Cells > Format > AutoFit Column Width. On Windows, the ribbon sequence Alt+H, O, I runs AutoFit Column Width; press the keys in sequence rather than all at once.

If the content should stay within a set column width, select the relevant cells and choose Home > Alignment > Wrap Text. Excel then displays the entry on more than one line where needed. If the row does not grow enough to show all lines, use Home > Cells > Format > AutoFit Row Height. To make one row taller by hand, drag the boundary beneath its row number.

On Excel for Mac, the same Home ribbon commands are available, and you can drag or double-click a column boundary. Ribbon keyboard sequences differ from Windows, so use the command on the ribbon rather than relying on the Windows Alt sequence. Excel for the web also provides Wrap Text and column sizing from the Home tab, though the exact ribbon layout can vary with the window size.

AutoFit columns without disrupting the sheet

AutoFit is useful when a worksheet has several columns whose contents vary in length. Select the columns you want to adjust, then choose Home > Cells > Format > AutoFit Column Width. Excel calculates a width based on the displayed contents in the selected columns. Double-clicking the boundary between two selected column headings applies AutoFit to those columns together.

AutoFit is not always the best choice for a polished report. One unusually long description can make its entire column very wide, pushing other information off-screen and making the sheet harder to scan. In that case, set a practical width by dragging the boundary, then turn on Wrap Text for the longer entries. Consider widening only the columns that need it rather than selecting the whole worksheet.

AutoFit also responds to the current contents and formatting. If the contents change later, the column does not necessarily resize itself every time. Run AutoFit again when needed, or choose a consistent manual width if the worksheet is a template used by other people.

Use Wrap Text when width must stay fixed

Wrap Text is often the right fix for headings, notes, addresses, and descriptions in a table. It keeps a column compact while showing content on multiple lines within the cell. Select the cells, then choose Home > Alignment > Wrap Text. You can apply the setting to one cell, a range, or an entire column.

Wrapping changes the presentation, not the cell value. For example, a heading such as Monthly service charge can appear on two lines in a narrow column while remaining one text entry. If you need a specific line break at a particular point, edit the cell and insert a manual line break: on Windows, press Alt+Enter while editing; on Mac, press Control+Option+Return. The exact key combination can depend on the Mac keyboard and Excel configuration.

Wrapping can make rows taller, so a table may become uneven. That is expected: Excel needs vertical room for the extra lines. If a wrapped entry still looks incomplete, select the affected row and use AutoFit Row Height. When text is very long, a fixed row height may conceal lower lines even though Wrap Text is active.

Check row height, merged cells, and alignment

A row can have a manually assigned height that is too small for its contents. This commonly happens after someone resizes rows for a compact layout, or when a workbook has been copied from another sheet with custom formatting. Select the affected rows and choose Home > Cells > Format > AutoFit Row Height. If a fixed height is required for the design, drag the row boundary until the full wrapped text is visible.

Merged cells deserve special attention. AutoFit may not calculate a merged cell’s required width or height as expected, because the text occupies a range treated as one display area. If possible, unmerge the cells and use Wrap Text, alignment, or a centered-across-selection layout instead. Before unmerging, check the range: when cells with different contents are merged, Excel keeps the upper-left cell’s content and removes the other entries from the merged range.

Alignment options can also affect what you see. Select the cell and open the Format Cells dialog with Ctrl+1 on Windows or Command+1 on Mac, then check the Alignment tab. If Shrink to fit is selected, Excel reduces the displayed text size to fit the column instead of expanding it. Indentation can use some of the available horizontal space. Adjust these settings only when they match the intended layout; changing the font size is not always a good substitute for fixing the column or row.

Tell clipping apart from truncation and hash marks

Clipping is a display issue: the cell still contains the text, but the worksheet grid does not show all of it. Select the cell and look in the formula bar. You can also copy the cell into a text editor or another blank cell to inspect the entry, taking care not to overwrite data. If the formula bar itself shows only a shortened value, the entry may have been shortened before it reached the cell or changed by a formula or import step.

Excel allows up to 32,767 characters in a cell, but the worksheet grid displays at most 1,024 characters from a cell. The formula bar can show more of a long entry. If a cell contains a very large block of text, widening the column will not make every character appear in the grid; use the formula bar or a suitable text-handling workflow to inspect the full value.

Hash marks such as #### are different from text clipped by the next cell. They commonly mean a numeric value or date does not fit in the column, so try widening it. If the column is already wide, check the number format and the underlying value. A date or number may be formatted in a way that takes more space than expected. Text entries usually do not turn into hash marks simply because the column is narrow.

Keep the fix when printing or sharing

A worksheet that looks fine on screen can still print with truncated text if rows or columns do not fit the printed page. Use File > Print to inspect the preview before printing. If the sheet is too wide, page orientation, margins, or scaling can affect its appearance. Scaling an entire sheet to fit one page may make text too small to read, so check the preview and consider printing across multiple pages instead.

Formatting can travel with pasted cells. If text became clipped after copying data from another workbook, inspect the column width, row height, and alignment in the destination. To remove unwanted formatting without deleting the contents, select the affected cells and choose Home > Editing > Clear > Clear Formats, then apply the formatting you want. Review the selection first: clearing formats also removes useful styles such as number formats, borders, and fill colors.

For a shared workbook, choose a layout that does not depend on one person’s screen size. Wrapped text and sensible widths are generally more predictable than relying on text spilling into neighboring blank cells, because those neighboring cells may later receive data.

Prevent text from being cut off in future

When building a table, decide whether each column should prioritize compactness or showing full entries. Use short, clear headings; set a reasonable width for routine values; and wrap only fields that commonly contain longer descriptions. A consistent layout is easier to read than repeatedly widening individual columns whenever a new long value appears.

  • After pasting data, check the longest entries and any adjacent cells that might block overflow.
  • Use AutoFit for an initial sizing pass, then manually reduce unusually wide columns if the sheet becomes unwieldy.
  • Use Wrap Text for notes and descriptive fields, and verify the row height afterward.
  • Check the formula bar before concluding that data has been deleted or shortened.
  • Preview important worksheets in File > Print before distributing or printing them.

Frequently Asked Questions

Why is Excel not showing the full text in a cell?
Usually the column is too narrow and the next cell contains something, preventing text from overflowing. Widen the column or enable Wrap Text. Select the cell and check the formula bar if you need to confirm the complete stored value.

How do I make Excel automatically fit text?
Select the relevant column or columns and choose Home > Cells > Format > AutoFit Column Width. For wrapped entries that are cut off vertically, use Home > Cells > Format > AutoFit Row Height.

Why does AutoFit not work for a merged cell?
Excel may not size rows or columns reliably around merged cells. Unmerge the range if practical and use wrapping or ordinary alignment; otherwise, adjust the row height and column width manually.

Does cut-off text mean Excel deleted part of my entry?
Not usually. A cell can hold more text than the grid displays. Select it and inspect the formula bar. Excel’s cell limit is 32,767 characters, while the worksheet grid displays up to 1,024 characters from a cell.

What does #### mean in Excel?
For a number or date, it commonly means the column is too narrow to display the formatted value. Widen the column first. If that does not help, review the number format and the value itself.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.