Forum Discussion
Is there another way to format a cell so you don't have to press alt + enter?
I need to write paragraphs similar to a word document, however the rest of the template is auto-populated from a database download on another tab. This is why I am constructing it in excel but one section requires free text for an analyst comment and I doubt I'll be able to convince the team to alt + enter for each new line. Is it possible to format a cell so that this isn't necessary? Or would it be easier to enter in multiple cells and merge? Thanks.
- Editing text in Excel isn't very user-friendly as you've discovered. Would a couple of text-boxes be an option perhaps? Disadvantage being that you cannot access the text in a text box from a formula.
