• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Wrap Text in Excel

March 16, 2021 by Andrew Childress
After wrap text in Excel

When your text won't fit nicely on a single line, You might want to wrap your text. Let's learn how to wrap text in Excel.

Sometimes, your text won’t fit nicely on a single line. In those cases, you might want to wrap your text so that it fits in a single cell. Let’s learn how to wrap text in Excel.

How to Wrap Text in Excel

Let’s look at the example below. The column labeled “Item Description” is a bit too wide, given that the items in the list are pretty short in width. This is a good opportunity to wrap the text, then downsize the column width.

Pre wrap text in Excel

Let’s click on Wrap Text in the Alignment section on the ribbon. You’ll see the text re-flow and make the row taller – instead of wider!

After wrap text in Excel

This is all that you have to do to wrap text in Excel. When your columns are getting a bit wide, wrap around the text and resize the column accordingly.

An Alternative to Wrap Text in Excel

The key idea when you wrap text in Excel is to make text fit in a relatively limited space by making the column taller. In some cases, your space may be extremely limited in width, but not in height. In those cases, making your text vertical is a great way to use the space.

Check out the image below to see what I mean. The “COGS” column feels a bit crowded, But notice that we have space above and below “COGS.”  This is a great time to change to Vertical Text.

Crammed column example

To change your text to being vertical, find the Alignment section on the ribbon, and click on the dropdown. Choose Vertical Text, and you’ll see the text shift to being typed vertically. Now, you’re using the full cell to show what you need to show.

As a finishing step, click on the Center alignment as you see below.

Vertical text

This approach isn’t technically a text wrap, but it accomplishes the same thing: arranging your text to make the best possible use of the space. Keep it in mind if your cell has space on the top and bottom.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Subscript in Excel font menu Subscript in Excel
Next Post: Superscript in Excel how to add Superscript in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top