Get the Wrap Text Practice Workbook
Want the file without building it from scratch? Download the ready-to-use workbook and follow along with every method in this tutorial.
- Practice wrap text, manual line breaks, and justify text with real examples
- See how to make long text fit neatly inside a single cell
- Includes Fill Justify examples for distributing text across multiple columns
Enter your email below for instant access.
What Does Wrap Text Do in Excel?
“Wrap Text” is a feature in Excel that lets you display long text on multiple lines within one cell.
Instead of the text spilling over, it fits neatly inside the cell by breaking into lines automatically.
Example
Before Applying Wrap Text:
After Applying Wrap Text:
If your text is overflowing because cells are merged, see our guide on how to merge cells in Excel for better alternatives.
How to Wrap Text Automatically
Follow these simple steps to fit text in in Excel automatically:
- Select Your Cell(s):
Click on the cell or drag your cursor over multiple cells. - Apply Wrap Text:
- Go to the Home tab in the toolbar.
- In the Alignment group, click on Wrap Text.
💡Shortcut Tip: Press Alt + H + W on your keyboard after selecting the cells.
That’s it! Your text will now appear on multiple lines within the same cell.
If you adjust the column width, Excel will automatically adapt the wrapped text to fit.
How to Add a Line Break in an Excel Cell (Alt+Enter)
Sometimes, you want full control over where the text wraps in a cell.
You can do this by inserting a line break yourself.
Here’s how:
- Double-Click the Cell:
Or pressF2to start editing. - Place Your Cursor:
Click where you want the new line to start. - Insert a Line Break:
PressAlt + Enter.
For example, your text says “Excel is easy to use,” and you want “to use” on a new line:
- Place your cursor before “to use” and press
Alt + Enter.
Need to combine text from multiple cells into one cell with line breaks? See our guide on how to combine two columns in Excel.
How to Justify Text in a Single Cell
Justifying text in Excel adjusts spacing to make your text fit perfectly inside one cell.
The text wraps into multiple lines, and the first and last words of each line align neatly with the cell’s edges.
It gives your spreadsheet a clean, professional look. Here’s how:
Step-by-Step Guide
- Select the Cell: Click the cell with the text you want to justify.
- Open Format Cells:
- Right-click the cell and choose Format Cells, or
- Use the keyboard shortcut
Ctrl + 1to open the dialog box.
- Choose the Justify Option:
- In the Format Cells box, go to the Alignment tab.
- Under the Horizontal drop-down menu, select Justify.
- Apply the Change:
- Click OK to see your text evenly spaced within the cell.
How Is Justifying Text Different from Wrapping Text?
- Text Wrapping: Breaks the text into lines within the cell but keeps the default left alignment.
- Text Justifying: Wraps the text and adjusts spacing, so each line (except the last) spans the full width of the cell.
How to Use Fill Justify Across Columns
If you have a long paragraph and want it displayed neatly across multiple rows within a set range of columns, Excel’s Fill Justify feature is your solution.
It breaks the text into smaller chunks and redistributes it across rows, ensuring it fits within your specified column width.
Steps to Distribute Text Across Rows and Columns
Let’s say you want to fit text within columns A to F.
Here’s how:
- Select the Range for Your Text:
- Highlight the cells where you want the text to fit, including columns and rows.
- For instance, select A1:F5 to create enough space for the text to distribute.
- Apply Fill Justify:
- Go to the Home tab.
- In the Editing group, click Fill, and choose Justify.
- Check the Results:
- Excel will break the text into smaller pieces and place it across multiple rows within the highlighted columns.
Know the Limitations of Fill Justify in Excel
Excel’s Fill Justify feature is handy for organizing long text. But there’s an important limitation you need to know: It only works with text up to 255 characters.
Anything after the 255th character will be deleted permanently.
How This Affects You
If you’re working with long paragraphs or detailed instructions, Excel might cut off part of your text.
Even if you undo the Justify feature, the deleted text will not come back.
What You Should Do
To avoid losing data:
- Double-Check Your Text Length: Before using Fill Justify, ensure your text is 255 characters or fewer.
- Keep a Backup: Copy your original text into a safe location before applying Fill Justify.
For more detail about how to use Fill Justify in Excel check out this blog post.
Download the Free Practice File
Take your Excel skills to the next level with our free workbook! This resource is packed with:
- Learn how to wrap text in cells, add line breaks, and distribute text across rows with practical scenarios.
- Step-by-step tasks to help you confidently use features like Wrap Text, Fill Justify, and AutoFit row height.
- Get shortcuts and tricks to save time and make your spreadsheets look professional.
📥 Download the Workbook Now and start mastering text wrapping today! Perfect for beginners and anyone looking to make their spreadsheets more organized and readable!
New to Excel formatting? Our Excel Essentials course covers wrap text, formatting, formulas, and more in a structured, beginner-friendly path.
Featured Course
Excel Essentials for the Real World
Leila Gharani
Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.
