View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default text wrapping in several cells

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" wrote:

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" wrote:

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" wrote:

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.