Wrap text

Copper Contributor

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...

7 Replies

@Margthom 

What exactly do you mean by "I want to have the wrapped text line up with the previous line."? Can you provide an example?

3 Lake Whatever: chocolate fudge
no nuts.

@Margthom 

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?

This is what I want...the text lined up....

you asked for a sample.... that was a sample of what I need

@Margthom 

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:

HansVogelaar_0-1695759388533.png

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:

HansVogelaar_1-1695759506642.png

 

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.

@Margthom 

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.