EXCEL TIPS how to word wrap in excel word wrap in excel excel word wrap wrap text in excel

How to Word Wrap in Excel — Complete Guide for 2026

Excel Expert

May 19, 2026

How to Word Wrap in Excel — Complete Guide for 2026

What Is Word Wrap in Excel?

When you type more text than fits in a cell's current width, Excel does one of three things by default:

Spills into the next cell — if the adjacent cell is empty, the text visually overflows into it
Gets cut off — if the adjacent cell has content, the text is hidden at the cell boundary
Wraps to the next line — only if Wrap Text is turned on for that cell

Word wrap (Wrap Text) enables option 3. It keeps all your text inside the cell by automatically increasing the row height to fit as many lines as needed.

Before word wrap:

| This is a very long sen... | Other Data |

After word wrap:

| This is a very long      | Other Data |
| sentence that wraps      |            |
| inside the cell.         |            |

Method 1 — Word Wrap Using the Ribbon Button (Fastest)

This is the quickest way to turn on word wrap for any cell or range in Excel.

How to do it:

Select the cell or range of cells you want to wrap
Go to the Home tab in the Excel ribbon
In the Alignment group, click Wrap Text

That's it. The row height automatically adjusts and all text becomes visible inside the cell.

To turn word wrap OFF: Click the same Wrap Text button again — it toggles between on and off.

To wrap an entire column:

Click the column header letter (e.g., click "B" to select the entire column B)
Click Wrap Text in the Home tab

To wrap all cells in the sheet:

Press Ctrl + A to select all cells
Click Wrap Text

Method 2 — Word Wrap Using Keyboard Shortcut

Excel doesn't have a single-key shortcut for Wrap Text, but you can use the Alt key sequence to trigger it without touching the mouse:

Windows shortcut:

Alt → H → W

Press Alt, then H (for Home tab), then W (for Wrap Text). Press them one at a time — not all at once.

This is the fastest way to wrap text without using the mouse — especially useful if you're doing a lot of formatting work and want to keep your hands on the keyboard.

Create a custom shortcut with a macro:

If you want a true one-key shortcut like Ctrl + Shift + W, you can create it with a simple VBA macro:

vba

Sub WrapTextShortcut()
    Selection.WrapText = Not Selection.WrapText
End Sub

Then assign it a keyboard shortcut:

Go to Developer → Macros
Select WrapTextShortcut
Click Options
Set shortcut to Ctrl + Shift + W
Click OK

Now pressing Ctrl + Shift + W toggles word wrap on any selected cells — just like a native Excel shortcut.

Method 3 — Word Wrap Using Format Cells Dialog

The Format Cells dialog gives you more control over text wrapping alongside other alignment settings.

How to access it:

Select your cells
Press Ctrl + 1 to open Format Cells (fastest way)
Click the Alignment tab
Check the Wrap text checkbox under Text Control
Click OK

Why use this method instead of the ribbon button?

Because the Alignment tab also lets you set:

Horizontal alignment (Left, Center, Right, Fill, Justify)
Vertical alignment (Top, Middle, Bottom)
Text orientation (rotate text at any angle)
Shrink to fit (alternative to wrapping — shrinks font size to fit)
Merge cells (combine adjacent cells)

You can set all of these at the same time as enabling word wrap — saving multiple ribbon clicks.

"Justify" alignment with word wrap:

In the Alignment tab, setting Horizontal alignment to Justify while Wrap Text is on makes text spread evenly across the full cell width — like justified paragraph text in a Word document. This is great for comments, notes, or description cells in reports.

Method 4 — Word Wrap an Entire Column Automatically

If you have a column that always contains long text — like a "Notes", "Description", or "Comments" column — you want word wrap to apply automatically to every cell in that column, including future entries.

Method A — Select whole column:

Click the column header (e.g., "C") to select the entire column
Click Wrap Text in the Home tab
Every cell in that column — current and future — will wrap text automatically

Method B — Set column wrap in a Table: If your data is in an Excel Table (Ctrl + T):

Click any cell in the column
Turn on Wrap Text
Excel applies it to the entire column in the table automatically

Method C — Use a cell style:

Go to Home → Cell Styles → New Cell Style
Name it "Wrapped Text"
Set the format to include Wrap Text
Apply this style to any column or range you want

This is useful for teams that need consistent formatting across multiple workbooks.

Method 5 — Word Wrap Using VBA (Automate for Entire Sheets)

When you need to apply word wrap across large datasets, multiple sheets, or as part of an automated workflow — VBA is the fastest approach.

Wrap text in a specific range:

vba

Sub WrapSpecificRange()
    Range("C2:C100").WrapText = True
End Sub

Wrap text in an entire column:

vba

Sub WrapEntireColumn()
    Columns("C").WrapText = True
    Columns("C").EntireRow.AutoFit  ' Also auto-fit row heights
End Sub

Wrap all cells in the active sheet:

vba

Sub WrapAllCells()
    Cells.WrapText = True
    Rows.AutoFit  ' Adjust all row heights to fit wrapped content
    MsgBox "Word wrap applied to all cells.", vbInformation
End Sub

Wrap only cells that contain more than N characters:

vba

Sub WrapLongCells()
    Dim cell As Range
    Dim minLength As Integer
    minLength = 50  ' Only wrap cells with more than 50 characters
    
    For Each cell In ActiveSheet.UsedRange
        If Len(cell.Value) > minLength Then
            cell.WrapText = True
        End If
    Next cell
    
    ActiveSheet.Rows.AutoFit
    MsgBox "Word wrap applied to all cells with 50+ characters.", vbInformation
End Sub

Wrap text across all sheets in the workbook:

vba

Sub WrapAllSheets()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Worksheets
        ws.Cells.WrapText = True
        ws.Rows.AutoFit
    Next ws
    MsgBox "Word wrap applied to all sheets.", vbInformation
End Sub

Toggle word wrap with VBA (on/off switch):

vba

Sub ToggleWrapText()
    With Selection
        .WrapText = Not .WrapText
        If .WrapText Then
            ActiveSheet.Rows.AutoFit
            MsgBox "Word wrap ON", vbInformation
        Else
            MsgBox "Word wrap OFF", vbInformation
        End If
    End With
End Sub

Method 6 — Add a Line Break Inside a Cell (Manual Wrap)

Sometimes you want to control exactly where the text wraps — not let Excel decide based on column width. You can insert a manual line break inside a cell.

Keyboard shortcut to insert a line break:

Alt + Enter  (Windows)
Ctrl + Option + Return  (Mac)

How to use it:

Double-click a cell to enter edit mode (or press F2)
Place your cursor exactly where you want the line break
Press Alt + Enter
Excel inserts a line break at that exact position
Press Enter to confirm

Important: Manual line breaks only show if Wrap Text is enabled on the cell. If Wrap Text is off, the line break is stored but invisible.

Finding cells with manual line breaks using VBA:

vba

Sub FindManualLineBreaks()
    Dim cell As Range
    Dim count As Integer
    count = 0
    
    For Each cell In ActiveSheet.UsedRange
        If InStr(cell.Value, Chr(10)) > 0 Then  ' Chr(10) = line break character
            cell.Interior.Color = RGB(255, 235, 156)  ' Highlight in yellow
            count = count + 1
        End If
    Next cell
    
    MsgBox count & " cells contain manual line breaks.", vbInformation
End Sub

Remove all manual line breaks with VBA:

vba

Sub RemoveLineBreaks()
    Dim cell As Range
    For Each cell In ActiveSheet.UsedRange
        If InStr(cell.Value, Chr(10)) > 0 Then
            cell.Value = Replace(cell.Value, Chr(10), " ")
        End If
    Next cell
    MsgBox "All manual line breaks removed.", vbInformation
End Sub

How to Fix Row Height After Turning On Word Wrap

One common issue: you turn on word wrap but the row height doesn't automatically expand — some text is still cut off at the bottom.

Fix — AutoFit row height:

Select the rows that aren't showing all wrapped text
Go to Home → Format → AutoFit Row Height

Or select all rows and AutoFit everything at once:

Click the top-left corner (where row numbers meet column headers) to select all cells
Go to Home → Format → AutoFit Row Height

VBA fix for row height:

vba

Sub FixRowHeights()
    ActiveSheet.Rows.AutoFit
End Sub

Why does this happen? When you manually set a row height (by dragging the row border), Excel locks that height and won't auto-adjust even when Wrap Text is on. AutoFit Row Height unlocks it and recalculates the correct height.

Word Wrap vs Shrink to Fit — Which Should You Use?

Excel offers two options for handling text that's too long for a cell:

You cannot use both at the same time — Excel disables Shrink to Fit when Wrap Text is on, and vice versa.

Common Word Wrap Problems and Fixes

Problem 1 — Wrap Text is on but text is still cut off Fix: The row height is manually locked. Select the row → Home → Format → AutoFit Row Height.

Problem 2 — Word wrap makes rows too tall Fix: Set a maximum row height manually. Select rows → Home → Format → Row Height → enter a specific height (e.g., 60).

Problem 3 — Wrap Text won't turn on for merged cells Fix: Wrap Text works with merged cells — but you may need to manually set the row height since AutoFit doesn't work on merged rows. Set row height manually: Home → Format → Row Height.

Problem 4 — Printing cuts off wrapped text Fix: Go to Page Layout → Print Titles, and make sure row heights are not set to a fixed size that cuts content. Also check Print Preview before printing.

Problem 5 — Word wrap applied but row height shows as 0 Fix: The row is hidden. Right-click the row number → Unhide. Then AutoFit Row Height.

Problem 6 — CSV files don't preserve word wrap Word wrap is a formatting property stored in .xlsx files only. CSV files have no formatting — word wrap settings are lost when saving as CSV. Always save a copy as .xlsx to preserve formatting.

Word Wrap Shortcuts — Quick Reference

Frequently Asked Questions

How do I turn on word wrap in Excel?

Select your cells, go to the Home tab, and click Wrap Text in the Alignment group. Your row height will automatically expand to show all the text. You can also press Alt → H → W as a keyboard shortcut.

What is the keyboard shortcut for word wrap in Excel?

The built-in key sequence is Alt → H → W (press one at a time). There is no single-key shortcut by default, but you can create one using a VBA macro assigned to Ctrl + Shift + W.

How do I word wrap an entire column in Excel?

Click the column header letter to select the entire column, then click Wrap Text in the Home tab. Every cell in that column — including future entries — will wrap text automatically.

How do I add a line break inside an Excel cell?

Press Alt + Enter (Windows) or Ctrl + Option + Return (Mac) while in cell edit mode to insert a manual line break at the cursor position. Make sure Wrap Text is enabled on the cell so the line break is visible.

Why is my text still cut off after turning on Wrap Text?

The row height is manually locked. Go to Home → Format → AutoFit Row Height to let Excel recalculate the correct height for wrapped content.

How do I word wrap in Excel using VBA?

Use Range("A1:A100").WrapText = True to enable wrap text on a range, and ActiveSheet.Rows.AutoFit to adjust row heights automatically. To wrap all cells: Cells.WrapText = True.

How do I remove word wrap from all cells at once?

Select all cells with Ctrl + A, then click Wrap Text in the Home tab to turn it off. Or use VBA: Cells.WrapText = False.

Does word wrap work in Excel on Mac?

Yes — Wrap Text works identically on Excel for Mac. Use the same ribbon button (Home → Wrap Text) or press Cmd + 1 to open Format Cells and check the Wrap text option in the Alignment tab.

Final Thoughts

Word wrap is one of those Excel features that seems simple but has a lot of depth once you know all the options. Whether you're wrapping a single cell for a report header, applying wrap text to an entire notes column, automating it across multiple sheets with VBA, or fixing the stubborn row height issues — you now have every tool you need.

Quick summary of all methods:

Try our free Excel tools — no upload, no signup:

🔗 Merge Excel Files — combine multiple workbooks instantly
🔗 Split Excel Files — split workbooks by sheet
🔗 VBA Macro Generator — generate any VBA macro in plain English
🔗 Excel to Word Converter — convert spreadsheets to Word documents
🔗 AI Excel Assistant — ask any Excel question, get instant answers