Skip to main content

How to wrap text in Microsoft Excel

Microsoft Excel may be a productivity app that emphasizes numbers, but it has useful tools for text as well. For instance, that handy spreadsheet app will let you wrap text. And getting it done is a breeze. In this guide, we'll show you how to wrap text in Excel in two ways: Manually and automatically.

Related Videos




5 minutes

What You Need

  • A PC

  • Microsoft Excel

How to wrap text in Excel using line breaks

Step 1: Go to the cell where you want to add the line break and double-click on it.

how to wrap text in excel insert line break screenshot 1

Step 2: Within that same cell, go to where you want to insert the line break, then click on that area.

Step 3: Then press Alt + Enter on your keyboard. A new line in that cell should immediately appear.

how to wrap text in excel wrapped using an inserted line break

How to wrap text in Excel using the Wrap Text formatting button

Step 1: Select the cells where you'd like the text to be wrapped. Then navigate to the Home tab of the ribbon menu at the top of the screen.

how to wrap text in excel automatically screenshot

Step 2: Look at the Alignment section of the Home tab and select the Wrap Text button. (The button has the "ab" on the top row and the letter "c" on the bottom row with a blue arrow between them that points toward the "c".)

This should automatically wrap the text in your selected cells.

Step 3: Alternatively: You can use a keyboard shortcut to automatically wrap text in Excel. To do so: Select your desired cells and then press Alt + H + W on your keyboard.

Don't forget to adjust your cell sizes

You may need to adjust the size of these cells to see the newly wrapped text better.

To do so: Mouse over their respective column and row borders until you see a black double arrow symbol. Then click and drag those borders until you've reached your desired cell sizes.

Editors' Recommendations

How to record a Microsoft Teams meeting
A video call in Microsoft Teams is displayed on a laptop.

Knowing how to record a Microsoft Teams meeting can save you so much time that's often spent asking for people to repeat instructions or remind you of what they said. Organizations may also want to record troubleshooting meetings for later analysis, compliance requirements, or to recall significant decisions that were made. Microsoft Teams understands this and has made the recording process simple to use – if it’s set up properly.

Read more
How to create a new team in Microsoft Teams
Example of Teams chat.

Microsoft Teams is one of the most popular communication applications for businesses, thanks to its useful integration with Office 365 and other compatible apps, along with the ability to create many different kinds of communication structures. One of the primary options is teams themselves — divisions of people focused on the same subject or task within a greater group — so knowing how to create a new team in Microsoft Teams is incredibly important to maximizing your organization's productivity.

Here’s how to quickly make one and your options for setting them up.

Read more
How to leave a team on Microsoft Teams
Microsoft Teams in Together mode on a laptop.

Microsoft’s popular business collaboration platform is a common choice for companies, volunteer projects, and more — especially if you’re already using Office 365 features. The ability to quickly join a group; find the right teams; and start discussion channels, chats, or video is a bonus for all users.

Read more