See all How-To Articles

How to Hide Overflow Text in a Cell in Excel & Google Sheets

In this tutorial, you will learn how to hide overflow text without wrapping in Excel and Google Sheets.

 

excel hide overflow text in a cell

 

When you enter text that’s longer than the cell’s width, Excel will automatically overflow the text to the next columns to display it. One way to fix this is to wrap the text so it displays on multiple lines but below, but here we’ll show how to hide the overflow text while keeping the cell at standard height.

Hide Overflow Text in a Cell

Without wrapping the text and increasing the cell height, you can prevent text displaying beyond the right cell border. In the below example, the text from cell B2 is displayed over cells C2 and D2.

 

hide overflow text in a cell initial data

 

To avoid this and cut off the text outside of cell B2’s borders, follow these steps:

  1. Select the text cell and in the Ribbon, go to HomeĀ > Alignment Settings.

 

hide overflow text alignment settings 1

 

  1. The Format Cells window will pop up. In the Alignment tab, choose Fill for Horizontal text alignment, and click OK.

 

hide overflow text alignment settings 2

 

As a result, the text in cell B2 is cut off to fit the cell height and is no longer overflowed to the other cells.

 

hide overflow text in a cell final data

 

Hide Overflow Text in Google Sheets

To achieve the same in Google Sheets, select a text cell and in the Toolbar, choose Text wrapping and click on Clip.

 

google sheets hide overflow text

 

You get the same result as in Excel.

 

google sheets hide overflow text 2