Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been viewed 53,757 times.
Learn more...
If you add enough text to a cell in Excel, it will either display over the cell next to it or hide. This wikiHow will show you how to keep text in one cell in Excel by formatting the cell with wrap text.
How to Keep a Text Value in One Cell
- Click the cell in your worksheet.
- Click the Home tab.
- Click Wrap Text in the ribbon at the top of Excel.
Steps
Download Article
-
Open your project in Excel. If you're in Excel, you can go to File > Open or you can right-click the file in your file browser.- This method works for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019-2007, Excel 2019-2011 for Mac, and Excel Starter 2010.
-
Select the cells you want to format. These are the cells you plan to enter text into and you'll be wrapping the text so they are easier to read.Advertisement -
Click the Home tab (if it's not already selected). By default, this tab is open, so you normally don't have to click Home unless you've navigated away from it.[1] -
Click Wrap Text. You'll find it in the "Alignment" group and your text will automatically wrap to fit the width of your column. If you expand or shrink the column/row size, the amount of visible text will change accordingly.[2]
Expert Q&A
Tips
-
If you want to add a line break within the cell, press Alt + Enter.[3]Thanks
You Might Also Like
References
- ↑ https://support.microsoft.com/en-us/office/wrap-text-in-a-cell-2a18cff5-ccc1-4bce-95e4-f0d4f3ff4e84
- ↑ https://support.microsoft.com/en-us/office/wrap-text-in-a-cell-in-excel-for-mac-b453fd03-f18f-4912-953c-2073da563cf7
- ↑ https://support.microsoft.com/en-us/office/insert-a-line-break-in-a-cell-a918e875-625e-4510-86d7-9f5873fe21c7
About This Article
1. Open your project in Excel.
2. Select the cells you want to format.
3. Click the Home tab.
4. Click Wrap Text.
Is this article up to date?
