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

|improve this answer|||||
  • 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
17

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

|improve this answer|||||
  • I came here searching for this answer, thank you! – Shimmy Oct 3 '19 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 '19 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.

|improve this answer|||||
-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)

|improve this answer|||||
New contributor
paddyg is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

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.