Copyright

Wrapping Text in Excel: How to Wrap Text within Cells

Wrapping Text in Excel: How to Wrap Text within Cells
Coming up next: The Number Format in Excel: Options & Properties

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:01 Wrapping Text
  • 1:19 The Format Cells Command
  • 2:30 Formatting to Wrap Text
  • 4:15 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Timeline
Autoplay
Autoplay
Speed

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Karen Sorensen

Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.

What if you could convert a long line of text entered on a spreadsheet to multiple lines? It would fit better for printing and be easier to read. This lesson will guide you through formatting cells to accommodate wrapped text.

Wrapping Text

Excel is often used to create spreadsheets using numbers. However, you may find yourself needing to add large amounts of text. For instance, you may have created a list of your friends that will receive Christmas cards this year. You have the basic information such as name and address, but you might also want to create a column for a note or comment. Maybe your friends travel and tend to be in different places, different times of the year. You may need to add a comment to their information detailing their schedule and travel plans, so you know where to send the card.

Wrapping text means you want your text to appear on multiple lines, rather than one long line of text. This allows you to keep the column width to a manageable size and consistent throughout your spreadsheet. Otherwise, you might need a cell that is 100 characters wide in order to fit the comment.

Excel has a feature that allows you to format a cell so that the text will be automatically converted to multiple lines, once the column width boundaries have been exceeded. You can also use the wrap text feature to control the way your header titles are displayed. This lesson will introduce you to the feature and demonstrate how to format cells to automatically format your text to display using multiple lines.

The Format Cells Command

There are two ways to access the Format Cells command, you can use the Ribbon or right-click. Let's take a look at using the ribbon commands.

  1. Go to the Home menu in the ribbon.
  2. Look in the Cells grouping of commands.
  3. Click on Format to expand the options menu.
  4. Select Format Cells (it's at the bottom of the list).

When the Format Cells dialogue box opens, it can be a bit intimidating. But no worries. These are simple options that allow us to change the way our text and numbers are displayed. You will see six tabs across the top of our dialogue box: Numbers, Alignment, Font, Border, Fill and Protection. In our lesson, we will focus on the Alignment properties. If you prefer the right-click method, you can place your cursor in the cell you want to format, right-click and choose Format Cells from the drop-down menu.

To unlock this lesson you must be a Study.com Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account
Support