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.
Table of Contents
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.
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 (overflow, wrap, 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:
- Open your Google Sheets spreadsheet.
- Select the cell or cells you need to format.
- From the menu, press Format > Wrapping > Wrap to wrap your textual content.
- To cancel textual content wrapping, press Format > Wrapping > Clip or Overflow as an alternative.
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.
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:
- Open the Google Sheets app and choose your spreadsheet.
- Select the cell or cells you need to format.
- Tap the Formatting button.
- From the pop-up menu, faucet Cell.
- Tap the Wrap textual content slider.
- To save your adjustments, faucet the save icon in the top-left.
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.
