How to Wrap Text in Google Sheets

Working on a Google Sheets spreadsheet

Text wrapping in Google Sheets permits you to deal with how your cell knowledge will seem as soon as it reaches the cell wall. Here’s how to use it.

Cells in Google Sheets are a set dimension. If the contents of your cells are overflowing, your cell knowledge goes to attempt to push past the cell border. Except—it gained’t (until the cell subsequent to it’s empty).

This isn’t the best manner to your Google Sheets presentation to look. You may change the cell sizing, however this may have an effect on the opposite cells in your rows or columns. A great way to get round that is to wrap textual content in Google Sheets.

If you need to understand how to wrap textual content in Google Sheets, observe the steps beneath.

What is Text Wrapping in Google Sheets?

A Google Sheets spreadsheet is a grid of cells. To cease the info in every cell from showing over the opposite, Google Sheets will conceal any knowledge that goes previous the cell boundary. The knowledge continues to be there—you simply can’t see it.

Example of text not wrapped in Google Sheets

An instance of textual content in a cell being clipped (not wrapped) in Google Sheets.

Text wrapping is a characteristic in Google Sheets (and different instruments) that adjustments this. If a quantity or textual content string in a cell is simply too massive for the cell, the cell will resize, forcing the cell worth onto a brand new line. It’ll proceed to do that to guarantee you possibly can all the time view your knowledge.

If you need to have the option to all the time view your knowledge with out choosing your cell, textual content wrapping is a good way to do it. You don’t want to resize your cells to do it, guaranteeing consistency throughout your spreadsheet.

Text Wrapping Options in Google Sheets

Before you start, nevertheless, you’ll want to know which kind of wrapping you’ll need to apply. You’ll have three choices to select from (overflowwrap, or clip).

Overflow will permit the contents of a cell to push over the cell boundary. Wrap will power the contents of your cell onto a brand new line (resizing the cell briefly). Clip, in the meantime, will truncate your seen cell contents as quickly because it reaches the cell boundary.

How to Wrap Text in Google Sheets on PC and Mac

If you need to wrap textual content in Google Sheets out of your net browser, you are able to do so through the use of the Format menu.

If you need to use textual content wrapping, you’ll want to choose the wrap possibility. You may also apply one of many different choices to permit textual content to be clipped or overflow your cell borders as an alternative.

To wrap textual content in Google Sheets on a PC or Mac:

  1. Open your Google Sheets spreadsheet.
  2. Select the cell or cells you need to format.
  3. From the menu, press Format Wrapping > Wrap to wrap your textual content.
  4. To cancel textual content wrapping, press Format WrappingClip or Overflow as an alternative.

Options to wrap text in Google Sheets

Running out of time? You may also rapidly allow or disable textual content wrapping in Google Sheets by urgent the Text Wrapping icon on the taskbar and choosing one of many obtainable choices.

The text wrapping menu icon in Google Sheets

How to Wrap Text in Google Sheets on Mobile

You may also allow textual content wrapping in Google Sheets on a cellular system. If you’re utilizing Google Sheets on Android, iPhone, or iPad, use the steps beneath to wrap your textual content.

To wrap textual content in Google Sheets on Android, iPhone, or iPad:

  1. Open the Google Sheets app and choose your spreadsheet.
  2. Select the cell or cells you need to format.
  3. Tap the Formatting button.
    The cell formatting option in Google Sheets
  4. From the pop-up menu, faucet Cell.
  5. Tap the Wrap textual content slider.
    The slider to enable text wrapping in Google Sheets on mobile
  6. To save your adjustments, faucet the save icon in the top-left.
    Saving changes to a Google Sheets spreadsheet on mobile

Formatting in Google Sheets

The steps above ought to provide help to to rapidly wrap textual content in a Google Sheets spreadsheet. Google Sheets provides quite a few different helpful instruments to provide help to format your spreadsheet.

For instance, you might have considered trying to conceal your gridlines to make your knowledge simpler to view. If you wished, you would even insert a picture right into a Google Sheets cell.

Having hassle? You can all the time share your Google Sheets spreadsheet and work on it collectively.