Download Article
Quick guide to make text fit in a cell
Download Article
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
-
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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- If you want to add a line break within the cell, press Alt + Enter . [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to sourceThanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
Advertisement
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
Article Summary
X
1. Open your project in Excel.
2. Select the cells you want to format.
3. Click the Home
tab.
4. Click Wrap Text
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 44,551 times.
Advertisement