How to Keep Text in One Cell in Excel

PDF download Download Article
Quick guide to make text fit in a cell
PDF download 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

  1. Click the cell in your worksheet.
  2. Click the Home tab.
  3. Click Wrap Text in the ribbon at the top of Excel.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f7\/Keep-Text-in-One-Cell-in-Excel-Step-1.jpg\/v4-460px-Keep-Text-in-One-Cell-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/f\/f7\/Keep-Text-in-One-Cell-in-Excel-Step-1.jpg\/v4-728px-Keep-Text-in-One-Cell-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/69\/Keep-Text-in-One-Cell-in-Excel-Step-2.jpg\/v4-460px-Keep-Text-in-One-Cell-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/6\/69\/Keep-Text-in-One-Cell-in-Excel-Step-2.jpg\/v4-728px-Keep-Text-in-One-Cell-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    These are the cells you plan to enter text into and you'll be wrapping the text so they are easier to read.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d5\/Keep-Text-in-One-Cell-in-Excel-Step-3.jpg\/v4-460px-Keep-Text-in-One-Cell-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/d\/d5\/Keep-Text-in-One-Cell-in-Excel-Step-3.jpg\/v4-728px-Keep-Text-in-One-Cell-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    By default, this tab is open, so you normally don't have to click Home unless you've navigated away from it. [1]
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ad\/Keep-Text-in-One-Cell-in-Excel-Step-4.jpg\/v4-460px-Keep-Text-in-One-Cell-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/a\/ad\/Keep-Text-in-One-Cell-in-Excel-Step-4.jpg\/v4-728px-Keep-Text-in-One-Cell-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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]
    5. 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

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Link Sheets in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      How to Combine Columns in Excel Without Losing Data
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/wrap-text-in-a-cell-2a18cff5-ccc1-4bce-95e4-f0d4f3ff4e84
      2. ↑ https://support.microsoft.com/en-us/office/wrap-text-in-a-cell-in-excel-for-mac-b453fd03-f18f-4912-953c-2073da563cf7
      3. ↑ 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?
      In other languages
      Thanks to all authors for creating a page that has been read 44,441 times.

      Is this article up to date?

      Advertisement