google sheets
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?
Here's a video explaining what I mean:
Here is what I did.
Hit ctrl+f to search, and click the "..." button representing more options
Typed \s+$ or \n in the find field
I hope it works for you. Also, you can replace \n with any regex expression and it can be immensely helpful.
This will sum the quantities, per row, for all rows in the range.
=ARRAYFORMULA(SUMIF(IF(COLUMN(C2:E4),ROW(C2:E4)),ROW(C2:E4),C2:E4))
I've created an example file for you: Sum over rows
Best Answer
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.