Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Wrapping Text in Excel: Formatting Foundations

April 13, 2016 by Tyrone Pernsley

Wrapping Text In Excel

Have you ever had so much data in one cell that that it spills over to the next cell or just disappears? And you don’t want to expand cells because it throws off data presentation in other cells? If you would like to solve this issue, then we are here to help you with wrapping text in Excel!

Like many excel features, there are short and long ways of executing the task. So we will show you both!

First, a quick way to wrap text for every cell is by going to the “alignment” section of your home toolbar and clicking the icon in the first row, 4th column.

Wrapping Text in Excel I1

If you hover over this icon with your mouse you will see it says, “Wrap text”. Click this icon and bam!, now all data will automatically be wrapped to fit the column width

The second way to do this is to first, highlight your desired cell or group of cells. Right click, select “format cells”, chose the “alignment” tab, check off “wrap text”, and click Ok.

Wrapping Text Gif

If all wrapped text is not visible, it may be because the row is set to a specific height so you may need to play around a little bit to get it to look how you want it too,

The nice part about excel is that you do not have to be afraid of getting your spreadsheet to look how you would like it too. With the text wrapping feature and your prior knowledge of adjusting rows and columns (from our previous post) you have the freedom to customize!

We hope you found today’s quick and easy Excel lesson beneficial. Don’t forget to follow ups on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Like Learn Excel Now? Sign up for the newsletter!

-Kevin, Learn Excel Now

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In