2

I have done a schedule in Google Spreadsheet. I set text wrapping to wrap. The problem is that when I write something in column A and the row in column A gets expanded to fit all text all other columns with the same row line up with that expanded size. I want to wrap text in just the column that I'm writing and not affect any other columns. How do I fix this?

Can I somehow isolate one column to not affect the other columns? Or is there another solution?

This picture describes what I want to achieve:

      A           B
| some text |___________|
| goes here |___________|
|___________|___________|
|___________|
|___________|
Improve this question

1 Answer 1

Reset to default
1

If you select the three rows in Column A and use the Format / Merge Cells / Merge All applied option, you get something which looks like that.

There is an example of how it looks in this sheet: https://docs.google.com/spreadsheets/d/1Sg-Rn_ZcNic8rpFek9DTlKtU-XuS4rukeZoyeQ4aLJA/edit?usp=sharing

The disadvantage is that it only works when you don't have any content in those rows in Column A. And it can make using some other spreadsheet features difficult. But if layout is most important to you, then it will work.

Improve this answer
2
  • I figured this out myself. But what I really were looking for was that the rows would come like this automatically without the need to use merge. So that I just needed to write in text and get the result automatically(without the need to calculate how many rows i needed for my text).
    – user3216616
    Mar 24, 2015 at 19:41
  • 1
    I'm afraid that's really not how spreadsheets work. Perhaps you should consider using a table in a Docs file instead of a spreadsheet.
    – MaryC.fromNZ
    Mar 25, 2015 at 10:34

Your Answer

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

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