The Google Sheets logo.

Thanks to Google Sheets’ ability to create new lines within a single cell, you can prevent your cell’s content from overflowing. Your extra cell content is put on a new line, and here are two ways to make that happen in your spreadsheets.

RELATED: How to Start a New Line in a Cell in Microsoft Excel

Use a New Line Within a Cell in Google Sheets

A quick way to enter a new line within a cell is by using a Google Sheets keyboard shortcut. This shortcut adds a new line whenever you want.

To use it, first, put your cursor in your cell and type the content for the first line.

Select a cell and type content.

When you want to add a new line, press the Ctrl+Enter (Windows, Linux, Chromebook) or Command+Enter (Mac) keyboard shortcut.

Add a new line in a celll.

Advertisement

Your cursor will move to a new line within the same cell. You may now type your second line’s content. To add a third line, again, use the same keyboard shortcut.

Enter second line's content.

And that’s how you prevent your text from overflowing and keep it within the boundaries of your cell’s width.

RELATED: All the Best Google Sheets Keyboard Shortcuts

Place Existing Cell Content on New Lines in Google Sheets

If your spreadsheet already contains overflowing text, and you want to put it all on new lines, use Sheets’ text wrapping feature.

First, select the cells in which you want to put the overflowing content on new lines.

Choose cells with overflowing text.

While your cells are selected, from Google Sheets’ menu bar, select Format > Wrapping > Wrap.

Select Format > Wrapping > Wrap from the menu bar.

Your overflowing cell content now fits the default width of the cell.

Text wrapped in Sheets.

And you’re all set.


If you use Excel, you can wrap text in your Excel spreadsheets, too.

RELATED: How to Wrap Text in Microsoft Excel

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »