I use Google Sheets to store product information and often the product description is broken in to numerous paragraphs with carriage returns. In Google Sheets this increases the height of the row, and I'm unable to reduce it to keep the row height uniform throughout the spreadsheet:
In Excel, both for desktop and online, a uniform height is achieved easily even if a carriage return is present in the cell:
Is there a way to achieve the same fixed/reduced height in Google Sheets?
Best Answer
I do not have a good answer for you directly.
But you are using the wrong tool. It's hard to get a nut off a bolt using a screwdriver.
Workarounds:
A: Other software. This may be a case where you need a free form database, or at least a database that has a text object as one of the fields. If you can afford it, try Filemaker Pro. Be wary of flat-file solutions. You will eventually need scripting, and relations.
B: Don't store the descriptions themselves in the spreadsheet, but instead put each description in a file. In Sheets put a hyperlink to the file in the form file://path/to/your/product/AJ7723.txt. (check that this syntax works before putting a bunch in place.) If you do this cleverly, you may be able to use the same files on your web server an include them as the page is generated.
C: An ugly solution: Replace carriage returns with some rare symbol such as solidus '|' This turns each description into a single run on paragraph, which will allow resizing.