A key talent to know when utilizing Google Sheets is the right way to wrap the textual content inside a cell. You need to have the ability to view the entire textual content that’s in your spreadsheet and never have any of reduce off. Setting phrase wrap is usually a bit tough till you recognize the place to look.

Setting Word Wrap

By default the textual content in a cell will spill into the following cell. This is especially problematic as a result of should you put content material into the following cell your textual content will probably be reduce off. It often doesn’t make sense on your textual content to be reduce off. Note that “cut off” isn’t literal, the textual content remains to be there. Double click on on the cell to view the complete textual content. The further characters are merely reduce off from viewing.

Find the Icon

Setting phrase wrap begins by choosing the cell or vary of cells that you want wrapped textual content in. In the toolbar, search for the centering icon. You could not see the icon in case your display width is just too small. In that case, you will notice 3 dots within the toolbar. Click on the three dots to see extra icons, together with the centering and wrap icon. The centering icon is mostly well-known to individuals and is simple to identify within the toolbar. The icon to the proper of the centering icon is an arrow pointing right down to a horizontal line. That lets you heart your textual content vertically, one other favourite of mine. The icon that’s to the proper of that’s the textual content wrapping icon.

3 Options

The default possibility is to overflow the textual content from the one cell to the following cell, if the following cell is obtainable. This is barely visually and doesn’t really put the textual content into the following cell. The worth of the cell to the proper 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 individual to see the complete URL.

Adjusting Column Width in Google Sheets

It can be useful to have the ability to modify the width of the column. If you have got a whole lot of textual content in your cell than a width of 120 pixels will probably be very troublesome to learn, even when the textual content is wrapped.

Hold your mouse between the column indicators. Click and maintain the mouse down to tug the width of the column wider.