A key skill to know when using Google Sheets is how to wrap the text within a cell. You want to be able to view all of the text that is in your spreadsheet and not have any of cut off. Setting word wrap can be a bit tricky until you know where to look.
Setting Word Wrap
By default the text in a cell will spill into the next cell. This is particularly problematic because if you put content into the next cell your text will be cut off. It usually does not make sense for your text to be cut off. Note that “cut off” is not literal, the text is still there. Double click on the cell to view the full text. The extra characters are simply cut off from viewing.
Find the Icon
Setting word wrap starts by selecting the cell or range of cells that you wish to have wrapped text in. In the toolbar, look for the centering icon. You may not see the icon if your screen width is too small. In that case, you will see 3 dots in the toolbar. Click on the 3 dots to see more icons, including the centering and wrap icon. The centering icon is generally well known to people and is easy to spot in the toolbar. The icon to the right of the centering icon is an arrow pointing down to a horizontal line. That allows you to center your text vertically, another favorite of mine. The icon that is to the right of that is the text wrapping icon.
