A key talent to know when utilizing Google Sheets is how one can wrap the textual content inside a cell. You need to have the ability to view all the textual content that’s in your spreadsheet and never have any of reduce off. Setting phrase wrap generally is a bit difficult till you understand the place to look.

Setting Phrase Wrap

By default the textual content in a cell will spill into the subsequent cell. That is notably problematic as a result of should you put content material into the subsequent cell your textual content can be reduce off. It often doesn’t make sense in your textual content to be reduce off. Notice that “reduce off” will not be literal, the textual content remains to be there. Double click on on the cell to view the total textual content. The additional characters are merely reduce off from viewing.

Discover the Icon

Setting phrase wrap begins by deciding on the cell or vary of cells that you need wrapped textual content in. Within the toolbar, search for the centering icon. You might not see the icon in case your display screen width is simply too small. In that case, you will notice 3 dots within the toolbar. Click on on the three dots to see extra icons, together with the centering and wrap icon. The centering icon is usually well-known to folks and is straightforward to identify within the toolbar. The icon to the correct of the centering icon is an arrow pointing right down to a horizontal line. That means that you can middle your textual content vertically, one other favourite of mine. The icon that’s to the correct of that’s the textual content wrapping icon.

3 Choices

The default possibility is to overflow the textual content from the one cell to the subsequent cell, if the subsequent cell is offered. That is solely visually and doesn’t really put the textual content into the subsequent cell. The worth of the cell to the correct stays clean.

The center possibility is the one you need, it wraps the textual content within the cell.

The third possibility is to chop off your textual content. I’ll use this for cells the place I’m pasting lengthy URL’s and it doesn’t matter for the particular person to see the total URL.

Adjusting Column Width in Google Sheets

It is usually useful to have the ability to regulate the width of the column. In case you have a number of textual content in your cell than a width of 120 pixels can be very tough to learn, even when the textual content is wrapped.

Maintain your mouse between the column indicators. Click on and maintain the mouse down to pull the width of the column wider.