EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Excel Wrap Text

By Pradeep SPradeep S

Home » Excel » Blog » Excel Tools » Excel Wrap Text

Wrap Text in Excel

Wrap Text in Excel (Table of Contents)

  • Wrap Text in Excel
  • How to Wrap Text in Excel?
    1. Using Wrap Text Option
    2. Using Format Cells Option

Wrap Text in Excel

Wrap text in Excel is used to wrap or enclose the selected cell’s content if the text in the cell is too big as if it crosses the borderline of the cell. Wrap Text is available in the Alignment section of the Home menu ribbon. Once we select a cell and click on Wrap Text, it keeps all the text or string within the limit of the cell without putting the characters in an extra line which we also can do by pressing ALT + ENTER together. But Wrap Text directly gives the complete text into a box.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

The limitation in the excel cell is that it will display only the first 1,024 characters in each cell. if it goes beyond, it is displayed as **

Sometimes you can notice, or you would have come across the below-mentioned scenarios, i.e.,

  • When you enter lengthy text in a cell, i.e. a long single-line text is longer than the cell’s width.

or

  • Already existing long lengthy text string in a cell, which exceeds the width of the cell.

or

  • A Cell is not a merged cell but a Cell containing a long text string,

The above scenarios in excel cell appear as mentioned below:

  • Longer text string overwriting empty adjacent cells

Wrap Text Step 1

If the adjacent column cell to the right is empty, a long text data string extends over the cell border into those columns.

  • Longer text string cut off due to the presence of text in an adjacent cell.

Wrap Text Step 2

If the adjacent column cell to the right contains any text or numeric data, then the text string will be cut off at the cell border.

Popular Course in this category
Sale
Excel Advanced Training (16 Courses, 23+ Projects)16 Online Courses | 23 Hands-on Projects | 140+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (11,408 ratings)
Course Price

View Course

Related Courses
Excel Training (21 Courses, 9+ Projects)

This large amount of text needs to be stored in spreadsheets and should fit in a cell.

As we can rectify the above two situations, either by just making the column wider at the border of the cell, where you can adjust manually or by doing just double click at the column border to automatically expand the column to fit the long text.

Both these options don’t work out when you have a huge number of columns & its text data to display.

It is possible to manually or automatically wrap the text (Explained in examples). It is a better option to wrap the text in the cells that have more text content.

Definition

Wrap Text is a feature in an excel spreadsheet that wraps or fits the text contents within a cell.

It auto-sizes the row height and column width when you paste the text into Excel.

It wraps or fits the cell contents on multiple lines, rather than a single or one long line without overlapping the text content to another adjacent cell.

Excel provides a “Wrap Text” option in the Alignment group on the Home tab of the ribbon. This button or option helps you out to toggle text wrapping on and off.

Wrap Text Step 3

The appearance of wrapped text in Excel cell.

Wrap Text Step 4

Advantage of text wrapping

  • It makes it easier to read the full-text contents in a cell.
  • It will better fit and easy to take a printout.
  • In the entire excel worksheet, if you wrap text, column width will be consistent and have a better display or appearance.

How to Wrap Text in Excel?

Let’s check out the various available options to WRAP text in excel.

You can download this Wrap Text Excel Template here – Wrap Text Excel Template

Example #1

Automatic wrap text within a cell in the spreadsheet

This method of wrapping text in excel is a very easy process, and it can be done in a faster way.

In the below-mentioned example, I have a long text in the cell B5 & B8 cell; suppose I want to wrap text in the cell “B8.”

Example 1-1

The first step is to Select cell “B8”, once you select the cell, you can observe black color at borders.

Wrap Text Example 1-2

Now, select the “Wrap Text” option in the Alignment group in the Home tab of the Excel ribbon.

Wrap Text Example 1-3

You can now observe the contents of the cell “B8” wrapped to fit the cell.

Wrap Text Example 1-4

Note:

  1. If you have initially set the row height to any number or manually set a row height or
  2. Adjusted column width by clicking on the right bottom border of a row header and dragging the separator towards left or right.

If you have used the above two options before doing wrap text, you will not observe any change in the row height or column width when you click the Wrap Text button.

If accidentally any changes are seen, then simply double-click the bottom border of a row header to fix this.

Example #2

Wrap text within a cell in the spreadsheet with the “format cells” option

The first step is to select a cell or group of cells in which you want to wrap the text content.

In the below-mentioned example, I have a lengthy text in the cell B5 & B8 cell; suppose I want to wrap text in the cell “B8.”

Example 2-1

Select a cell “B8”, once you select a cell, you can observe black color at borders.

Example 2-2

Now, Right-click on the selected cell and go to Format Cells.

Wrap Text Example 2-3

Or select the font arrow dropdown option in the Font group on the Home tab of the Excel ribbon.

Wrap Text Example 2-4

Once you have selected a cell which you need to wrap, you can press Ctrl + 1 to open the Format Cells dialog.

Wrap Text Example 2-5

In the Format Cells dialog box, select alignment subtab; select the Wrap Text check box and click OK.

Format Cells Example 2-6

Now, you can observe the text contents of the cell “B8”, which is wrapped to fit in the cell.

Wrap Text Example 2-7

Compared to the first method, this one may take extra time & might take a couple of extra clicks, but at a single shot, it will help you make other changes in cell formatting with various options in the format cells window.

Things to Remember About the Wrap Text in Excel

  • If the text is wrapped and you want to unwrap it, select the cell or group of cells which needs to be unwrapped.
  • Again, you have to select the “Wrap Text” option in the Alignment group on the Home tab of the Excel ribbon.

Wrap Text note

  • Sometimes, the wrapped text will not be visible due to the fixed row height you would have done in prior; this can be rectified by clicking on autofit options. i.e. selecting the “format” option in the cells section, on the Home tab of the Excel ribbon. Cell size drop-down appears in that select AUTOFIT ROW HEIGHT.

AUTOFIT ROW HEIGHT 1

  • The wrap Text option in excel is not applicable for merged cells.

Recommended Articles

This has been a guide to Excel Wrap Text. Here we discuss how to Wrap Text in excel using the format cells option and wrap text option along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. Compare Text in Excel
  2. Excel Text with Formula
  3. VBA Text
  4. Formatting Text in Excel

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (34+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Wrap Text Excel Template

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Wrap Text Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

Independence Day Offer - EXCEL ADVANCED Training Learn More