PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO USE WRAP TEXT IN GOOGLE SHEETS?

INTRODUCTION

“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.

WHERE TO FIND WRAP TEXT BUTTON IN GOOGLE SHEETS?

WRAP TEXT option can be found on the DEFAULT TOOLBAR as shown in the picture below.

text wrap google sheet
BUTTON LOCATION FOR WRAP TEXT IN GOOGLE SHEETS

WRAP TEXT option is also found under the DATA MENU> TEXT WRAP.

text wrap google sheets
BUTTON LOCATION FOR WRAP TEXT IN GOOGLE SHEETS IN MENU

WHEN TO USE WRAP TEXT IN GOOGLE SHEETS ?

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.

 

DIFFERENT OPTIONS FOR WRAP TEXT IN GOOGLE SHEETS ?

GOOGLE SHEETS three different options for Wrapping Text in the way you want.

These are-

OVERFLOW:

This is the default setting of every cell. If we type in any cell and it overflows, Google Sheets would show it completely. The example is shown below. [ But mind it, it is just placed in the cell where it starts, only visual is overlapping; nothing else ]

 

 

OVERFLOW WRAP TEXT

WRAP:
THIS IS THE STANDARD WRAP TEXT WHICH WE KNOW. ALL THE TEXT IS WRAPPED UP IN THE SAME CELL. The width of the cell is adjusted to accommodate all the text in the same cell.

 

 

 

text wrap google sheets
WRAP TEXT IN GOOGLE SHEETS

CLIP:

This option clips the overflowing portion of the text visually. [ Only the text is not shown visually, no change in the original text ].
This option can be used when we don’t want any change in the size of the cells because if we use the WRAP FUNCTION, it removes the uniformity of the cells to wrap the text as per the individual requirement of each cell.

 

 

 

text wrap google sheets
CLIP WRAP TEXT IN GOOGLE SHEETS

EXAMPLE OF WRAP TEXT IN GOOGLE SHEETS

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.

STEPS TO WRAP TEXT IN GOOGLE SHEETS

  • Select the cell/cells where the WRAP TEXT needs to be applied.
  • CLICK on the button OVERFLOW, WRAP, OR CLIP WRAP TEXT directly from the toolbar or by going through the DATA MENU> TEXT WRAP> OVERFLOW/ WRAP /CLIP as per the requirement of the report.
  • The result is visible as shown in the picture.
  • The complete text is shown in the cell by increasing the height of the row in Wrap, by clipping the extra portion in clip and by overflowing through other cells in OVERFLOW setting.
excel wrap text

After applying WRAP TEXT , all the content is fully visible. This demo shows the use of wrap text.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: