Forum Discussion
EXCEL - Setting default row height in combination with word wrap
I am trying to make a more user-friendly worksheet for rapidly entering moderate amounts of data. My data is in a standard matrix with the fields as columns and the entries as rows. The default row...
I have a similar challenge with entering text into cells when the amount of text is larger than the default row height.
I've had some success in splitting the text content laterally in the same row, and in a few cases separating the text into logical groups into the next row (or several rows).
When I have a topic with a list of alternative bullets (letters or numbers) below that relate to that specific topic, I can't separate the text content.
The users tell me that the Word format isn't as useful as Excel (I've tried both formats).
The best alternative for me in my project is to set the default row height higher so that "word wrap" simply expands the row height enough to show the contents.