Skip to main content

How to hide overflowing text without populating an entire cell with the content in Excel?

Author: Zhoumandy Last Modified: 2022-08-29

When there are long text strings in cells, they will spill over to the next cells. The easy way to prevent the text from overspilling is using the Format Cell feature in Excel. But the shortcoming of this method is that when a cell contains short text, Format Cell feature will fill the entire cell with the content, repeating as many times as necessary. Like a cell containing the text “you” may look like “youyouyou”. So, is there any way to hide overflowing text without populating an entire cell with the content in Excel? The answer is yes. In this tutorial, we will show you three methods to get the job done.
doc hide-overflowing-text-without-populating 1

Hide overflowing text using Wrap Text

Keep text from overflowing with a space

Prevent text from overflowing using an amazing tool

To prevent text in the table below from spilling over to the neighboring cells using the Wrap Text feature, please do as follows.

1. Select the cells that you want to prevent from spilling over.

2. Go to the Home tab and click Format > Row Height in the Cells group.
doc hide-overflowing-text-without-populating 2

3. In the popping-up Row Height dialog, keep the default row height unchanged. Then click OK.
doc hide-overflowing-text-without-populating 3

4. On the Home tab, click the Wrap Text button in the Alignment group.
doc hide-overflowing-text-without-populating 4

Now you can see the overflowed texts in the cells are hided and are kept from spilling over to the next cells.
doc hide-overflowing-text-without-populating 5

Another way of preventing the overflowing text is making the neighboring cells not empty. Just enter a space in the next range or column to hide the over-spilling text. Please do as follows.

1. Select the range or the entire column next to the overflowing cells.

2. Enter a space character in it.
doc hide-overflowing-text-without-populating 6

3. Continue to press Ctrl + Enter, so each cell of the selected range or column will be inserted a space. You can now see there is no overflowing text.
doc hide-overflowing-text-without-populating 7

In addition to the above two methods, here I introduce to you another simple way to keep the text from overflowing. The Fill Blank Cells feature of Kutools for Excel can do the trick in a few clicks.

Before applying Kutools for Excel, please download and install it firstly.

1. Select the range or the entire column next to the overflowing cells.

2. Go to Kutools tab, and click Insert > Fill Blank Cells.
doc hide-overflowing-text-without-populating 8

3. The Fill Blank Cells dialog box pops up. Check the Fixed value option and type a space in the Filled value box.
doc hide-overflowing-text-without-populating 9

4. Click the OK button. You will see the overflowing cell contents are hidden. And all selected cells are filled in with a space.
doc hide-overflowing-text-without-populating 10

Other Operations (Articles)

How To Quickly Insert A Line Based On Current Date In Excel?
Supposing there is a sheet containing a row with dates, and now I want to insert a line right to the current date which will auto change while opening the workbook every day. Is there a trick can solve it in Excel?

How To Always Insert A Blank Row Below Instead Of Above In Excel?
As we all known, when inserting blank row in a worksheet, the blank row will always be inserted above the selected row or cell. But, sometimes, you may need to insert the row below the selected cell or row. How could you solve this job in Excel?

How To Insert A Blank New Row Automatically By Command Button In Excel?
In many cases, you may need to insert a blank new row into a specified position of your worksheet. In this article, we will show you how to insert a blank new row automatically by clicking on a Command Button in Excel.

How To Insert A Blank Row After Specific Text In Excel?
If you want to insert blank rows after a specific text as following screenshot shown, how to deal with it quickly and easily without inserting them manually one by one?

  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
kte tab 201905
  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
but i want it to over flow but am unable to do it some time it hide text like next cell dont have space but it has and some time it increse row height both i dont want , what can be done
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations