Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

If you enter a long bit of text into a cell in Microsoft's Excel the text flows out of the cell over the top of the adjacent cells. This doesn't happen by default in Google Spreadsheet - it flows under the adjacent cells.

Is there a way to make Google Spreadsheet behave like Excel in this way?

(This is nothing to do with wrapping or re-sizing cells.)

share|improve this question

1 Answer 1

Seems to do what you want by default (maybe because New Google Sheets?). You say (This is nothing to do with wrapping or re-sizing cells.) yet it does seem to be a matter of wrapping:

WA42297 example

I think A1 is what you require. But as with Excel, the text in A2 is truncated where there is content in B2. A3 may be what you are describing as undesirable, achieved here with clicking the icon shown on the extreme right of the image.

share|improve this answer

Your Answer

 
discard

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.