Tips & Tricks - 2026-05-12

Wrap Text in Excel: Complete Guide

Learn how to wrap text in Excel, add line breaks, fix row height, align text, and make long labels readable in reports.

What Wrap Text Does

  • Wrap Text displays long cell content on multiple lines inside the same cell. It makes labels, notes, comments, and descriptions easier to read. Use: Home -> Wrap Text

Add a Manual Line Break

  • While editing a cell, use: \\\ Alt + Enter \\\ This inserts a line break inside the cell.

Fix Row Height

  • If wrapped text is cut off, adjust row height: Home -> Format -> AutoFit Row Height You can also double-click the row boundary.

Wrap Text with Formulas

  • Use CHAR(10) with TEXTJOIN or concatenation: \\\ =A2&CHAR(10)&B2 \\\ Turn on Wrap Text so the line break displays.

Related Guides

  • How to Combine Cells in Excel TEXTJOIN function Merge Cells in Excel Excel Keyboard Shortcuts

Quick win checklist

  • Try the shortcut or setting on a copy of your file first. Pin the technique to your Quick Access Toolbar if you will use it daily. Pair productivity tips with Excel Tables and named ranges for fewer broken references. Explore: Tips archive · Keyboard shortcuts guide

Frequently asked questions

  • How do I wrap text in Excel? Select the cells and choose Home > Wrap Text.
  • How do I add a line break inside an Excel cell? Press Alt + Enter while editing the cell.
  • How do I remember this Excel tip? Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.
  • Will this tip work on Mac Excel? Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.