16

In Microsoft Office Excel a long text string is readable over multiple columns whenever the next (right) column is empty. Is that also possible within Google Spreadsheet?

0
31

If you do not want your text to overflow use Format > Text wrapping > Clip. This will work even if the next cell is empty.

3
  • I came here searching for this answer, thank you! Oct 3 '19 at 10:38
  • This should be the accepted answer. The actual accepted answer doesn't provide any useful information at all. Oct 10 '19 at 9:06
  • Some kind of contents won't follow the overflow rule. For example if there is an implicit formatting, like dates, currencies...
    – Sandburg
    Jan 19 '21 at 10:01
5

That's only possible when you're using the new Google Spreadsheet:

screen shot without text in adjacent column

and now with text in column B:

screen shot with text in adjacent column

Read all about the new Google Spreadsheet in this official blog

3
  • It would be much appreciated if this feature could be turned off. It clutters up the display if you optionally have text in the column to the right.
    – Jonny
    Feb 5 '15 at 6:51
  • Did you test @black_falco answer? I don't know back then, but now it works for me.
    – tokland
    Jan 15 '16 at 9:05
  • This answer is outdated. Hiding overflow can now be performed, cf Quentin Caron's answer
    – Nino Filiu
    Apr 1 '19 at 14:38
2

If Format - Text wrapping - Clip isn't resolving your issue, try:

Select All (Ctrl+A or Ctrl+Shift+Space) and Ctrl+/ to Clear Formatting.

Can be also done from the Format menu (at the top), choose the last Option, Clear Formatting.

0
-1

This problem can also arise if there is some clever cell merging - as is often the case if using templates. Either select the existing cells and adjacent one doing the cut-off and Format-MergeCells-.. or unmerge them (or use tool at the top of page)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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