In this tutorial, you will learn how to hide overflow text without wrapping in Excel and Google Sheets.
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.
To avoid this and cut off the text outside of cell B2’s borders, follow these steps:
- Select the text cell and in the Ribbon, go to Home > Alignment Settings.
- The Format Cells window will pop up. In the Alignment tab, choose Fill for Horizontal text alignment, and click OK.
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 Google Sheets
To achieve the same in Google Sheets, select a text cell and in the Toolbar, choose Text wrapping and click on Clip.
You get the same result as in Excel.