This article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 43,397 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 How.com.vn 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
- 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
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?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.