howto.org.in

How to Wrap Text in Excel

Learn how to wrap text in Excel with the Wrap Text button, row height, line breaks, merged-cell caveats, troubleshooting, and FAQs.

DocumentsEdited by Pramod Tiwari
2 min read

Quick Answer

To wrap text in Excel, select the cell or range, go to Home, click Wrap Text, then adjust row height or column width if the text still looks clipped.

What You Need

  • Excel workbook
  • Cell with long text
  • Home tab access
  • Row height or column width controls

Safety Precautions

  • Save important work before bulk formatting.
  • Avoid wrapping huge ranges unnecessarily because it can change sheet layout.
  • Check printed pages after wrapping.
  • Be careful with merged cells, which can behave unpredictably.
  • Do not hide critical text with fixed row heights.

Step-by-Step Instructions

  1. Step 1

    Select cells

    Click one cell or select a range with long text.

  2. Step 2

    Open Home tab

    Go to the Home tab on the ribbon.

  3. Step 3

    Click Wrap Text

    Use the Wrap Text button in the Alignment group.

  4. Step 4

    Adjust column width

    Widen or narrow columns to improve readability.

  5. Step 5

    Adjust row height

    AutoFit row height if wrapped text is clipped.

  6. Step 6

    Add manual line break

    Use Alt+Enter inside a cell when you need a specific break.

  7. Step 7

    Preview print

    Check print layout if the sheet will be exported or printed.

Practical Example

Example: A notes column is too wide, so you select it, click Wrap Text, and AutoFit row height so every note is visible.

Common Mistakes

  • Forgetting row height
  • Wrapping entire sheet
  • Using merged cells
  • Not checking print preview
  • Confusing shrink-to-fit with wrap text
  • Leaving columns too narrow

Troubleshooting

Text is still cut off

AutoFit row height or increase row height manually.

Rows became too tall

Widen the column or shorten the text.

Wrap Text does not work in merged cells

Unmerge cells if possible and use a normal range.

Printed sheet looks messy

Adjust page layout, scaling, and column widths.

FAQs

Where is Wrap Text in Excel?

Home tab, Alignment group.

What is the shortcut for a line break in a cell?

Use Alt+Enter on Windows.

Why is wrapped text hidden?

Row height may be fixed too small.

Does Wrap Text change the cell value?

No, it changes display, not the underlying text.

Help us improve this guide

Tell us about an outdated instruction, unclear step, broken link or safety concern. Do not include passwords, account numbers, medical records or other sensitive information.

Email a correction or suggestion