7

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?

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

  • 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 at 14:38
15

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

  • I came here searching for this answer, thank you! – Shimmy Oct 3 at 10:38
  • This should be the accepted answer. The actual accepted answer doesn't provide any useful information at all. – Bruno Finger Oct 10 at 9:06
1

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.

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.