Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone know how to make it so that Word Wrap is OFF by default in Google Spreadsheets?

share|improve this question
up vote 7 down vote accepted

There is not, at this writing, a global setting that would automatically affect all new spreadsheets that you create.

To turn off word wrap on any sheet, select all the cells of the sheet and select the "Wrap text" option from the toolbar:

Wrap text option on the Docs toolbar circled

Once all cells have word wrap turned off, it will also be true that new rows and columns will have word wrap turned off, because they take their formats from their neighbors.

However, when you cut and paste a range (or drag-move a range), the empty cells left behind revert to the default format. For this reason, I do not cut and paste. Instead I copy and paste, then reselect the original range and backspace or delete to blank values. This leaves the format intact.

share|improve this answer
That's no fun. Thank you for your answer! – SouthFresh Dec 8 '11 at 14:56
Note that the "word wrap" option is not under any menu - it's only in the toolbar. – Erel Segal-Halevi Jul 15 '12 at 8:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.