11

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

2 Answers 2

8

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.

3
  • 6
    Note that the "word wrap" option is not under any menu - it's only in the toolbar. Jul 15, 2012 at 8:31
  • There's only 3 options for this Wrap text button: "Overflow" "Wrap" and "Clip". There's no "Disable" option :(
    – Hlung
    Feb 25, 2019 at 7:41
  • @Hlung What would it do?
    – MetaEd
    Feb 27, 2019 at 20:18
0

As noted above, there is currently no way to change the defaults for this or, apparently, other features like font or font size.

@erel-segal-halevi: Text wrapping is (now) on the Format menu, not just in the menu bar.

Quick key combination to update your entire spreadsheet to Wrap Text:

Ctrl-a Alt-o then w then down-arrow

Select all; Open Text Wrap Submenu; Select Wrap Text (from overflow - the default)

1
  • 1
    Please note that "above" has no context here. Answers can be sorted a number of ways and, even if left at the default sort, the order can change as votes accumulate on answers. Better to provide a link to the answer to which you are referring.
    – ale
    Jun 5, 2018 at 16:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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