In Excel for Microsoft 365 on Windows, select the cell or cells, choose Home > Wrap Text, then choose Home > Format > AutoFit Row Height. If text is still clipped, check for a fixed row height or merged cells, which can stop Excel from displaying every wrapped line.
Why Excel hides text in a cell
Excel separates the value stored in a cell from the space available to display it. A cell may contain a long sentence, but the grid has to fit that sentence within the column width and row height. If the available space is too small, Excel may show only part of the text, display it on multiple lines, or let it extend visually into a neighboring empty cell.
What you see depends on the cell’s alignment settings and the cells around it. For example, if A2 contains “Quarterly sales increased after the spring campaign” and B2 is empty, the text may appear to spill across B2. Put a value in B2, and the visible spill stops at the cell boundary. The text in A2 has not been deleted; it is simply not all visible in the grid.
The quickest dependable fix for a long note is usually to wrap the text and give the row enough height. Widening the column can also help, but it changes the layout for every row in that column. Choose the adjustment that suits the worksheet rather than assuming a cell itself can expand independently of the grid.
Wrap Text and AutoFit: what each setting does
Wrap Text breaks a cell’s displayed text across multiple lines within the existing column width. It changes how the contents are shown, not the underlying text. AutoFit Row Height adjusts the row’s height to accommodate the wrapped lines. For both settings, select the relevant cells first; to affect the whole worksheet, use the Select All button at the top-left corner of the grid, then apply the settings.
These controls solve different parts of the problem. Turning on Wrap Text without increasing the row height can leave lower lines hidden. Increasing the row height without wrapping may leave a long, unbroken line extending across the row, where neighboring cell contents can block it. If your goal is to see every line in a narrow column, use both.
- Select the affected cell, range, or rows.
- On the Home tab, select Wrap Text.
- Choose Home > Format > AutoFit Row Height.
- If the result is still cramped, widen the column by dragging its right boundary in the column headings, or use Home > Format > AutoFit Column Width.
AutoFit Column Width bases the width on the contents of the selected column. That can be convenient for a short data list, but a single long entry may make the whole column impractically wide. For notes and descriptions, wrapping in a deliberately sized column is often a better fit.
Check for a manually set row height
A row can have a fixed height from a previous formatting choice. In that case, wrapped text may extend below the visible portion of the cell because the row has not grown to fit it. Select the row and use Home > Format > AutoFit Row Height. You can also place the pointer on the lower boundary of the row number and double-click to AutoFit that row.
To set a specific height instead, select the row and choose Home > Format > Row Height, then enter a value. A fixed height can make a carefully aligned report look consistent, but it may clip text if the contents later change. If a sheet is regularly updated, consider using AutoFit or leaving enough height for the expected number of wrapped lines.
On Windows, the key sequence Alt, H, O, A opens AutoFit Row Height through the ribbon KeyTips. Press the keys in sequence rather than all at once. The corresponding sequence for AutoFit Column Width is Alt, H, O, I. In Excel for Mac, use the ribbon’s Format controls or double-click the boundary below the row number; the Windows Alt sequence does not apply in the same way.
Merged cells are a frequent cause
AutoFit is unreliable with merged cells. When several cells are combined into one, Excel may not calculate the row height from the wrapped text as expected. As a result, the text can remain clipped even after you select AutoFit Row Height. This is a common reason a fix that works elsewhere in the sheet seems to fail in a particular heading or form field.
If possible, unmerge the cells and use another layout method. Select the merged area, then choose Home > Merge & Center > Unmerge Cells. Apply Wrap Text and AutoFit Row Height to the resulting cells. If the heading should still look centered across several columns, select those cells and use Format Cells > Alignment > Horizontal > Center Across Selection, where available in the Format Cells dialog. Unlike merging, this alignment option does not combine the cells.
If you must keep the merge, adjust the row height manually by dragging its lower boundary or using Home > Format > Row Height. Estimate the space needed from the number of wrapped lines, then inspect the result. A merged cell spanning several columns may wrap differently when any of those column widths change, so revisit the row height after changing the layout.
Other reasons text may still look cut off
Work through these checks before changing the contents or rebuilding the worksheet:
- Wrap Text is off. Select the cell and check Home > Wrap Text. A long line cannot display on multiple lines until wrapping is enabled.
- The row is too short. Run AutoFit Row Height again, or increase the height manually. A fixed height can persist even after you turn on wrapping.
- A neighboring cell blocks overflow. If you want text to spill across empty cells instead of wrapping, make sure the cells to the right are empty. Any content in the next cell—including a space or a formula that returns an empty string—can prevent the spill from appearing.
- The column is narrow. Drag its right edge wider, or use AutoFit Column Width. If a column contains one exceptionally long entry, a wider column may be less useful than wrapping.
- The cell contains line breaks. A line break forces a new displayed line. In Excel, Alt+Enter inserts a line break while editing a cell on Windows. On Mac, the shortcut differs by keyboard and Excel version; use the in-cell editing controls if the shortcut does not work. Each forced line needs vertical space.
- Text is being shrunk to fit. Open Format Cells > Alignment and check whether Shrink to fit is selected. This reduces the displayed font size to keep text on one line; it does not make the row taller. Turn it off if you want wrapped text at the normal font size.
Also distinguish clipped text from a display or zoom issue. Change the worksheet zoom or widen the window to see whether the grid is merely difficult to read. Zoom changes the on-screen scale, not the underlying row height, column width, or cell contents.
Choose between wrapping, widening, and shrinking
The best method depends on what the worksheet is for. A data table with many records usually benefits from consistent column widths and wrapped descriptions. A compact dashboard may need short labels and carefully chosen widths. A print-ready form may need manually set row heights so the printed page stays orderly.
- Use Wrap Text for comments, addresses, descriptions, and other text that should remain inside a fixed-width column.
- Widen the column when the entries are short enough that a modest increase improves readability without disrupting the rest of the sheet.
- Use Shrink to fit only when keeping a value on one line matters more than keeping a uniform font size. It can make long entries noticeably smaller.
- Increase row height manually when you need a consistent layout or are working with merged cells that AutoFit does not handle well.
These choices affect more than one cell in many cases. Column width applies to the entire column, and row height applies to the entire row. If a table has text that varies greatly in length, wrapping can make some rows taller than others; that is normal, but it may affect how easily the table scans or prints.
When the issue appears after editing or printing
If text was visible and then became clipped, consider what changed: a neighboring value may have been entered, a column may have been narrowed, or a row height may have been set. A formula can also return a longer text result than before. Reapply Wrap Text and AutoFit Row Height to the affected range, then check whether merged cells or manual dimensions are involved.
Worksheet view and print layout are related but not identical. Text that fits on screen can still be difficult to read on a printed page if the sheet is scaled to fit too many columns onto one page. Before printing, use File > Print to inspect the preview. Adjust page orientation, margins, scaling, or column widths as appropriate; do not assume that increasing a cell’s row height will solve every print-layout problem.
If only part of a sentence is visible in the formula bar as well as the grid, confirm that you are selecting the intended cell and that the stored value is what you expect. If the formula bar shows the complete text but the grid does not, the issue is usually display space or alignment rather than missing content.
Frequently Asked Questions
Why does Excel show only part of my text?
There may not be enough room in the cell’s row or column, or a neighboring cell may block text from overflowing. Turn on Wrap Text and AutoFit Row Height, then check for merged cells and fixed row heights.
How do I make Excel automatically adjust row height?
Select the rows or cells and choose Home > Format > AutoFit Row Height. You can also double-click the boundary below a row number. If the cells are merged, you may need to set the height manually.
Why does AutoFit Row Height not work?
Merged cells are a frequent cause, and manually fixed heights or text wrapping can also be involved. Try unmerging the cells, applying Wrap Text, and running AutoFit again. If you need to retain a merge, adjust the row height yourself.
Can text show across empty cells without wrapping?
Yes. Text can visually overflow into adjacent cells when those cells are empty and the alignment allows it. If a neighboring cell contains anything, the spill is blocked. Use Wrap Text when you need all text visible within the original cell instead.
Does changing zoom make the whole cell text appear?
No. Zoom changes how large the worksheet looks on screen; it does not change cell contents or create more row height. Use wrapping, AutoFit, or a width and height adjustment to change how much text the grid displays.
Related
- Conditional Formatting: Highlight Duplicates in Excel
- Data Validation Testing: Methods and Examples
- Data Validation Studio: Excel Rules, Setup, and Limits
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Not Responding: How to Fix Freezes and HangsIf Excel keeps showing “Not Responding,” first give it a little time if it may be calculating or…
- Excel UNIQUE Function Not Working? Fix Common ErrorsIf Excel’s UNIQUE function is not working, first check that your Excel version supports dynamic arrays, then inspect…
- VLOOKUP Not Working Unless I Click the Cell?If VLOOKUP appears wrong until you click into its cell and press Enter, Excel is usually not recalculating…
- Excel Spill Error: Causes, Fixes, and ExamplesAn Excel spill error, shown as #SPILL!, means a formula that returns multiple results cannot place them all…
- Outlook Share Calendar Button Not Working? How to FixIf Outlook’s Share Calendar button is missing, disabled, or does nothing, first check that you are using a…
- Google Sheets Wrap Text Not Working? How to Fix ItIn Google Sheets, wrap text often seems broken because the cell is set to Overflow or Clip, the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.