QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Wrap Text in Excel?

By Neha T Leave a Comment

Excel allows you to wrap text in a cell so that it becomes presentable and easy to read. If the length of the string in your cell is long enough to fit into the cell, it overlaps the content of another cell while writing and is partially visible when we move on from that cell.

The wrap text option of Excel allows the string of a cell to appear in multiple lines within the cell. While wrapping the string in the cell it doesn’t change the format of the text. In this section, we will discuss four different ways to wrap a lengthy string in the Excel cell.

  1. Using Wrap Text Option
  2. Manually Breaking the Line
  3. Using format Cell Option
  4. Using Keyboard Shortcut

Steps to Wrap Text in Excel:

Using Wrap Text Option in Excel

Write a long string in a cell as you can see in the image below.

Wrap Text in Excel 1

Now click on the cell with the lengthy string and from the Home tab, in the Alignment group click on the Wrap Text option.

Wrap Text in Excel 2

By default, the text is aligned at the bottom you can align it to the middle of the cell. And you can even adjust the cell size by dragging the borders of the cell.

By Manually Breaking Lengthy Text in a Cell

Double click on the cell with the lengthy string. Now click on the location at the string where you want to break the line.

Wrap Text in Excel 3

And then press Alt+Enter, this will break the line from the location where you have clicked.

Using Format Cell Option

Select the cell with the long string that you want to wrap. Right-click on the cell and from the displayed menu you have to click on the Format Cells… option.

Wrap Text in Excel 4

In the ‘Format Cells’ window, go to the Alignment tab, and in the ‘Text control’ section you have to check ‘Wrap text’ option. And click on OK.

Wrap Text in Excel 5

Using Keyboard Shortcut

Though excel does not have any dedicated shortcut to wrap the long string in the Excel cell. Select the cell with lengthy string and press:

Alt + H + W

So with these methods, you can wrap the long string in the Excel cell to make it properly visible.

You Might Also Like:

How to convert text to number in Excel - Featured ImageHow to Convert Text to Number in MS Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? how-to-break-links-in-ms-excel-2016-featured-imageHow to break Links in MS Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? Lock Formulas or a Cell in Excel - feature ImageHow to Lock Formulas or Cells in Excel? Insert Checkbox in Excel - feature imageHow to Insert Checkbox in Excel? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows in Excel? Calculate Average in Excel feature imageHow to Calculate Average in Excel?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to convert PDF to PowerPoint Presentation
  • How to Change Login Screen Background in Windows 10?
  • How to Find a Computer’s MAC Address on Windows 7
  • How to Change a Drive Letter in Windows 7
  • How to Change Your Username in Gmail?

Copyright © 2023 · QueHow · Contact Us