WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Wrap Text in Excel

Wrap Text in Excel

What is Wrap Text in Excel?

Wrap text in Excel belongs to the “Formatting” class of excel function that does not make any changes to the value of the cell but just change the way a sentence is displayed in the cell. This means that a sentence that is formatted as warp text is always the same as that sentence that is not formatted as a wrap text.

How to Wrap Text in Excel Automatically and Manually?

This is the most simple and quickest method of using the function of Wrap text.

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

Method #1 – By using the Wrap Text Option from the Ribbon

Select the cell that needs the Wrap Text and then go to the Home Tab and then from there, choose the option of wrap Text. We will get the text displayed as below after Wrap Text.

Wrap Text method 1

Method #2 – Using the Formatting Cell Option to use Wrap Text.

Sometimes for those people who do not use the mouse often, they can use this Keyboard excel shortcut to wrap text.

  • Step 1 – Select the cell that needs Wrap text and then press the shortcut key CTRL+1.

method 2

  • Step 2 – After the keyboard shortcut is pressed, then the below window, from where we can choose the function of Wrap text and then click on OK.

method 2-1

Method #3 – Wrap Text Using the Keyboard Shortcut

Wrap text can also be directly applied by the below keyboard shortcut.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Wrap Text Shortcut

First, we need to press the Alt key. Then we need to release the Alt key and press the H key.

We will be applied to the first selected cell. After the H key is pressed and released, then we need to press the W key and Wrap text.

method 3-1

Method #4 – How to Insert a Line Break Manually?

We can make some changes to the excel Wrap text function. We can as per we will insert a line break as per our need.

To insert a line break, we just need to take the cursor to that part of the cell, where we need to insert a line break.

Now we need to press the below keys at one time.

ALT + Enter key

Refer to the below-given Screenshot

method 4

Things to Remember

  • Wrap text in excel will not work on Cells that are merged.
  • Wrap text function will not work if the width of the cell is already more than the width of the sentence that is entered into that cell. In this case, we need to use a line break if we need the format of the wrap text.
  • This feature might not work if “Height of Row” is fixed manually. In this case, we need to change the Row height to the “Automatic row height” function.

Recommended Articles

This has been a guide to Wrap Text in Excel. Here we discuss how to wrap text in excel using shortcut keys for wrapping the text along with practical examples and downloadable excel templates. You may also look at these useful functions in excel –

  • Format Text in Excel
  • Separating Text in Excel
  • Add Text in Excel Formula
  • Change Case in Excel
5 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download Wrap Text Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More