How to fix text overflow in Google Sheets

In fact, you already have the option to reformat cells in Google Sheets when entering text, to avoid the case of text overflowing to the next cell. We don't need to resize the cell, save on manipulation. The following article will guide you how to fix text overflow in Google Sheets.

Method 1: Adjust the overflow text in Sheets through the Format menu

In the text box where you want to compact the text in the same cell, click to select and then click on the Format above.

How to fix text overflow in Google Sheets Picture 1

In the menu shown below, we click on the item Automatic newline and then choose next Newline to automatically return the text. By default, Google Sheets to Spill mode so the text will overflow to the cell next to it.

How to fix text overflow in Google Sheets Picture 2

The resulting text has been carriage return in the same cell

How to fix text overflow in Google Sheets Picture 3

In addition, if you choose Cut, the text will be hidden and will not get a newline, nor will it be overflowed.

How to fix text overflow in Google Sheets Picture 4

Method 2: Fix the text overflow in Sheets through the toolbar

If you do this quickly, then use the icons in the toolbar in Sheets . We also click on the box to align the text, and then click on the Automatic line break as shown.

How to fix text overflow in Google Sheets Picture 5

Now display 3 different icons, from left to right including Spill, Newline and Cut. If you want the text to automatically go to line, you choose Newline, if you want the text to automatically cut, press Cut.

So, depending on the layout and layout requirements in the document, you can choose Newline or Cut so that the text is only in 1 cell, not overflowing to the next cell.

How to fix text overflow in Google Sheets Picture 6

Micah Soto

Update 13 September 2020