How to Wrap Text in a Cell in Microsoft Excel

The Problem with Long Text in Excel

Microsoft Excel is designed primarily for numbers, short data points, and concise formulas. However, in the real world, you often need to insert long sentences into your spreadsheets—such as project descriptions, customer feedback, or meeting notes.

When you type a long sentence into a standard Excel cell, it behaves in one of two frustrating ways:

• If the cell next to it is empty: Your text will bleed over the lines, covering up the adjacent empty cells in a long, unbroken string.
• If the cell next to it contains data: Your text will be cut off completely at the border, hiding the rest of your sentence behind the adjacent data.

You should never try to fix this by manually hitting “Enter” to create fake line breaks. The correct solution is to use the Wrap Text feature, which automatically forces the cell to expand vertically, keeping all your text neatly contained within the original column borders.

How to Wrap Text in Excel

Wrapping text takes less than two seconds once you know where the button is.

1. Open your Excel spreadsheet.
2. Click on the specific cell (or highlight a group of cells) containing the long text that you want to fix.
3. Look at the main Ribbon menu at the top of the screen and ensure you are on the Home tab.
4. Find the Alignment section (usually located near the middle of the ribbon).
5. Click the Wrap Text button. (The icon usually looks like a small ‘ab’ with a curved arrow pointing down and to the left).

Excel will instantly calculate how much space your text needs. The column width will remain exactly the same, but the row height will expand downward, creating multiple lines of text within that single cell so you can read everything clearly.

How to Manually Adjust the Row Height

Sometimes, after clicking Wrap Text, the cell does not expand enough, and the bottom line of your text remains hidden. You can easily fix this by manually adjusting the height of the row.

1. Look at the grey numbers running down the far left side of your spreadsheet (these are the Row Headers).
2. Hover your mouse exactly on the horizontal line dividing the row you want to adjust and the row beneath it (e.g., the line between row 4 and row 5).
3. Your cursor will change into a horizontal line with two vertical arrows pointing up and down.
4. Click and drag downwards to increase the height of the row until all your text is visible.

Pro Tip: Instead of dragging, simply double-click that dividing line. Excel will automatically “AutoFit” the row, expanding it to the exact millimeter required to display your wrapped text perfectly.

How to Insert a Manual Line Break (Alt + Enter)

The standard “Wrap Text” button allows Excel to decide where to break your sentences based on the width of the column. However, what if you are typing an address and want to force a specific line break (e.g., putting the city and post code on their own separate line)?

If you press the standard “Enter” key on your keyboard, Excel will simply jump to the next row down. You must use a keyboard shortcut to stay inside the same cell.

1. Double-click inside your cell so the blinking text cursor appears.
2. Click exactly where you want the line break to occur.
3. Press and hold the Alt key on your keyboard (or Option if you are using a Mac).
4. While holding Alt, press Enter.

Your cursor will instantly drop to a new line within that exact same cell. You can use this shortcut as many times as you need to format addresses, bullet points, or lists directly inside a single Excel box.