up vote 8 down vote favorite
3
share [g+] share [fb]

In a Google Doc spreadsheet I would like to have each row the same height no matter how much text is in each cell.

I have tried "resize row" but no matter how many pixels I put in, the row expands downward to the height of the highest cell with full expanded text.

How can I force the row to stay a certain height and insert scrollbars for all text that is longer than that height?

alt text

Here's a video explaining what I mean:

http://screenr.com/Ol4

link|improve this question
35% accept rate
I can't find a way to do it. I'd be interested in seeing a solution to this as well. – Al Everett Sep 22 '10 at 12:55
There may be a way to show a limited amount of content and then expand it or open in a box onclick using a custom script. How tied are you to the particular interface scetched in your image? – Dan Roberts Oct 1 '10 at 1:19
The solution I need to to be able to paste "endless text/images" into the little cells so that I can zoom in and look at all that text if I want but can at any time, back up and get an overview of all my notes and code. Right now, I cannot get this overview since the long texts and code inserts expand everything so far down the page. – Edward Tanguay Oct 7 '10 at 7:21
feedback

6 Answers

up vote 12 down vote
+50

There is no solution for this one. This is just how HTML works. They are using Table for the cells and by default it's not adding scroll bars if the text doesn't fit. Maybe they will change it in the future, but I don't think that this is in their priority list. And it looks like you can merge cells only horizontally, just in case you wanted to merge vertically to make it look nicer.

link|improve this answer
1  
I wonder why they didn't implement overflow:scroll on cells to allow for this. – Al Everett Oct 6 '10 at 21:39
feedback
up vote 1 down vote

If they're not offering the feature your only option may be to create a Greasemonkey script, assuming you want it that bad.

link|improve this answer
feedback
up vote 1 down vote

I agree, that so far this is impossible but have you tried using different hex characters like NBSP for your text? This would make things ugly and lose your formatting I noticed without carriage returns the length of the entry has no bearing on the height.

Edit: You should also submit your (very well presented idea) here

link|improve this answer
feedback
up vote 0 down vote

Try this link - Rows and columns: Changing row height and column width

link|improve this answer
yes, that link shows how to make the height of a row larger, but I want to make the height of the row smaller and have the text inside it (which has newlines, not wrapped) scroll inside the cell, I explain the difference here in a video: screenr.com/Ol4 – Edward Tanguay Oct 2 '10 at 3:19
feedback
up vote 0 down vote

Fourth option from the right (Menu bar - once you're in the spreadsheet with the results, etc.). There is an option "WRAP TEXT", select the rows you want and click it.

link|improve this answer
feedback
up vote 0 down vote

There is no actual way, wrapping will effect cell width not it's height. Whenever it bothers me I add the text as a comment block. Simply right click on a relevant cell and select "comment" off the context menu; delete the auto generated text and paste yours. This way you'll be able to maintain a fixed row height for all your rows.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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