Wrap text in Google Sheets

Learn how to wrap text in a single cell, entire row, or entire column

When you enter a significant amount of text into a Google Sheets cell, it can overlap other cells and columns if it doesn’t fit in the current cell. Depending on your settings, the text may not overlap adjacent cells, but instead be truncated, making it virtually invisible until you click in the cell itself.

Any of these steps can be problematic, making your tables look untidy and difficult to read or navigate. Text wrapping allows you to maintain some semblance of order in your document by ensuring that all text appears on multiple lines in its cell.

Wrap text in Google Sheets

  1. Select one or more cells that contain the text you want to wrap. You can also select entire columns or rows if desired.

    To apply text wrapping to the whole worksheet, first click the blank box at the intersection of column A and row 1 headings. All cells in active sheet should be selected now, then you need to follow the steps below.

  2. Click on menu Format at the top of the Google Sheets browser tab.

  3. When the drop-down menu appears, hover over the option Text wrapping

  4. A submenu will now appear with the following three options: overflow wrap around and clamp † Select wrap around

  5. All text in selected cells should now be wrapped properly. You can cancel these settings at any time by repeating the previous steps and selecting overflow or clamp

Leave a Reply

Your email address will not be published. Required fields are marked *