“WRAP TEXT IN GOOGLE SHEETS IS THE PROCESS OF WRAPPING(folding or compacting) THE TEXT TO MAKE IT VISIBLE IN A SINGLE CELL”.
WRAP; as the word has literal mean of folding things up and the option is available in many other applications like notepad, is similar in the case of GOOGLE SHEETS too.
WRAP TEXT option can be found on the DEFAULT TOOLBAR as shown in the picture below.
WRAP TEXT option is also found under the DATA MENU> TEXT WRAP.
WRAP TEXT: In GOOGLE SHEETS, if you type a long text in a cell and it has filled the visible area of the cell, it’ll start overlapping over the content of the other cell, and when you click the other cell the text of the first cell will be hidden.(The situation is shown in the picture below).
Think of a situation when you want your text to be clearly visible all the time. So we use this function WRAP TEXT for that particular situation.
GOOGLE SHEETS three different options for Wrapping Text in the way you want.
The complete text is ” Welcome to Gyankosh” But the cell is showing only the portion-“Welcome TO”, “GYANKOSH.NET” is hidden and “THIS IS OTHER” is shown as it is in the next cell.
Lets apply different wrap text options and check the results.
After applying WRAP TEXT , all the content is fully visible. This demo shows the use of wrap text.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE