GOOGLE SHEET AUTO TEXT WRAP

GOOGLE SHEET AUTO TEXT WRAP

Step 1: Go to Tools > Script Editor and put the following code there:

function wrap(e) {

e.range.setWrap(true);

}

Step 2: Still in Script Editor, go to Resources > Current project's triggers, and select from drop-downs "wrap", "From spreadsheet", "On form submit".

NOTE: If under Resources you have no current project triggers - create a new one - name it "wrap" - then proceed to choose "From Spreadsheet", "On Form Submit" and it will work as stated.

Step 3: You're done. Close the Script Editor. The new form submissions will be automatically wrapped in the spreadsheet.