Download Article
Download Article
This article was co-authored by wikiHow staff writer, Hannah Dillon. Hannah Dillon is a Technology Writer and Editor at wikiHow. She graduated with a B.A. in Journalism from North Dakota State University in 2013 and has since worked in the video game industry as well as a few newspapers. From a young age Hannah has cultivated a love for writing and technology, and hopes to use these passions in tandem to help others in the articles she writes for wikiHow.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
Learn more...
Have you ever written in an Excel sheet and noticed that your text sometimes gets cut off if you're writing something longer than the cell? While this is frustrating, you can easily fix it by enabling text wrapping. You can enable text wrapping for one cell, or you can set it for the entire sheet. You can also manually add line breaks if you prefer. Keep reading to learn how.
Text Wrapping in Excel
To wrap text in Excel, click on a cell and choose Wrap Text in the Home tab. You can apply text wrapping to all cells by selecting the entire document and clicking Wrap Text. Alternatively, manually line break in a cell by pressing Alt+Enter (Windows)/Ctrl+Opt+Return (Mac).
Steps
-
Select the cell you want to add text wrapping to. If you don't have your Excel sheet open, make sure to open it up now.- While text wrapping makes it so the text won't get cut off based on the width of the cell, you can change the width of the cell at any time. The word wrapping will persist no matter how wide the cell is.
-
Click on the Home tab. This is the first tab in the ribbon, and it's the default tab. If you are already on this tab, you can skip this step.Advertisement -
Click the Wrap Text button. It's in the "Editing" subsection of the Home tab. Once you click this button, the text in the cell will immediately wrap and adjust the height of the cell to accommodate the text inside of it.[1]- If the cell height doesn't automatically adjust to accommodate the text in the cell, double-click the bottom border of the cell.
-
Select all the cells in your document. You can do this by pressing Ctrl+A (Windows)/⌘ Cmd+A (Mac), or by clicking the arrow in the upper-left corner of the spreadsheet. -
Click on the Home tab. This is the first tab in the ribbon, and it's the default tab. If you are already on this tab, you can skip this step. -
Click the Wrap Text button. It's in the "Editing" subsection of the Home tab. Once you click this button, any text that's currently being cut off in the sheet will wrap onto a new line. However, all of the cells in the document will now be formatted to word wrap even if they're currently empty.[2]- If the height of the cells doesn't automatically accommodate any current text in the cells, do the following:
- In the Home tab, click Format in the "Cells" group.
- Choose AutoFit Row Height under "Cell Size."
- If the height of the cells doesn't automatically accommodate any current text in the cells, do the following:
-
Select the cell you want to add a line break in. This can be a cell that's currently empty, or the cell can have text in it already. -
Get to the point where you want to add a line break. If the cell is empty, type content into the cell until you've reached the right edge of the cell. If the cell has text, click into the cell and place your blinking line cursor where you want to add the line break.[3] -
Press Alt+↵ Enter (PC) or Ctrl+⌥ Opt+⏎ Return (Mac). A manual line break will be inserted where you placed your cursor.[4]- If you adjust the width of this cell later, the line break will remain in the same place. You'll have to go back and change where the line break is located to make the text wrap neatly in the cell again.
Expert Q&A
Video
Tips
References
- ↑ https://support.microsoft.com/en-us/office/wrap-text-in-a-cell-in-excel-2a18cff5-ccc1-4bce-95e4-f0d4f3ff4e84
- ↑ https://support.microsoft.com/en-us/office/wrap-text-in-a-cell-in-excel-2a18cff5-ccc1-4bce-95e4-f0d4f3ff4e84
- ↑ https://support.microsoft.com/en-us/office/wrap-text-in-a-cell-in-excel-2a18cff5-ccc1-4bce-95e4-f0d4f3ff4e84
- ↑ https://support.microsoft.com/en-gb/office/start-a-new-line-of-text-inside-a-cell-in-excel-33e41eab-8b5e-4193-93d6-9a06ecf812b3#ID0EBBF=macOS&id0ebbf=macos
About This Article
