Forum Discussion
EXCEL - Setting default row height in combination with word wrap
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.
Same question I asked the original poster in this thread: what is the nature of the project or task here? Are you using Excel solely for its nice row and column layout of cells, or are you also using it for calculations, functions, sorting or sifting? Calculations can include text functions as well....
But if all you're doing is entering text and wanting it to look organized, then despite what your users might be saying, it seems to me that Word would be the default: it's far more capable of handling lots and lots of text, and the table format in Word is quite versatile. Each program has its advantages and disadvantages, of course, but I haven't seen anything in what you've written to convince me that Excel is the right choice.