text wrapping in several cells

[ramona]

I'm wondering if it's possible to have text wrap in one column but in all the
cells of the column. Currently this 'chart' is in Word but I may need to put
it into Excel so we can 'lock' some of the cells that are not to be written
in. However, they would like to keep the lines and the separate cells so
that they won't have to manually write in a line at the end of the entered
data once it's printed. This column is for nurse's info and will only be
keyed into at the initial time of the patient visit. It will then be printed
out so they will need the rest of the lines in the column for future notes.
Is this clear as mud and is it possible?

This is the greatest help line I've ever used. And I'll understand if it
can't be done. So thanks for everyone's assistance in advance.

 

[Eduardo]

Hi Ramona,
yes you can, highlight all the cells you want to wrap, then right click on
the mouse, format cell, go to the 2nd tab Alignment, and under Text control
check Wrap text

 

[ramona]

Thank you very much, Eduardo, but I knew I hadn't expressed it very well.
What I would like is for all the data that is keyed into the first cell to
wrap into the next cell or cells (as many as are needed which is always
unknown). They don't want the height of the first row to change. This way
all the data will look as if it has been written (entered) in each cell down
the column after printing. I hope this makes it a little clearer. And I know
I'm asking a lot, but I am still just wondering if this is possible.

Thank you again everyone.

 

[Eduardo]

Hi Ramona,
So the only way you have is for example to highlight row 2 columns A to E
and press Merge, that will give the results but I don't think that is what
you are looking for

 

[ramona]

Hello, Eduardo,

Thanks again, but you're right. That isn't what I wanted. I did, however,
find the answer and I thought I would just add it in here in case someone
else looked for the answer here.

Under 'Can Excel work like Word?', question from Rob, Stephen Bye wrote:
"Edit > Fill > Justify will move text into the next row..."
This is EXACTLY what I am looking for. Thank you so much for your time and
have a wonderful day.

 

[Gord Dibben]

Not possible to have Excel reach the right side of a cell then wrap down to
the next cell.

You must tell Excel when to leave a cell by hitting the Enter key.

You could use a macro to split the long text string in one cell into
multiple cells at a designated length or point.

Example string...................

The quick brown fox jumps over the lazy dog while enjoying an afternoon in
the park.

How would you want this split up into cells?


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Good find.

I forgot all about that feature.


Gord