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
Thanks, but can you explain what you mean by this?
Is it an example of what you want?
Or an example of what you don't want? If the latter, what would the desired result be?
Margthom
Sep 26, 2023Copper Contributor
This is what I want...the text lined up....
you asked for a sample.... that was a sample of what I need
you asked for a sample.... that was a sample of what I need
- HansVogelaarSep 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:
- MargthomSep 26, 2023Copper ContributorThanks 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.- 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.