Forum Discussion
Margthom
Sep 26, 2023Copper Contributor
Wrap text
I can wrap text fine in the excel spreadsheet, however I want to have the wrapped text line up with the previous line. I can't seem to find the way to do this. Comments please...
HansVogelaar
Sep 26, 2023MVP
If you enter 3 Lake Whatever: chocolate fudge no nuts in a cell and turn on Wrap Text, where the text will break depends on the width of the cell:
If you want to make sure that no nuts ends up on the next line, click just before it and press Alt+Enter. This inserts a line break:
Margthom
Sep 26, 2023Copper Contributor
Thanks but you'll see that no nuts is underneath the number not the text. ( which is not what I want)
I've figured it out by making a line break and pressing the space bar to get 'nuts' to move over.
Thanks anyway.
I've figured it out by making a line break and pressing the space bar to get 'nuts' to move over.
Thanks anyway.
- HansVogelaarSep 26, 2023MVP
How could I have known? "no nuts" was underneath the number 3 in your post too...
Anyway, Excel does not have hanging indents like Word; it is not a text processor.