Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in several cells
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in several cells
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in several cells
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in several cells
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. "Eduardo" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in several cells
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 On Tue, 17 Mar 2009 12:05:04 -0700, 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in several cells
Good find.
I forgot all about that feature. Gord On Tue, 17 Mar 2009 13:12:01 -0700, ramona wrote: 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. "Eduardo" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrapping text in merged cells | Excel Discussion (Misc queries) | |||
wrapping text in merged cells | Excel Discussion (Misc queries) | |||
Text wrapping in cells | Excel Discussion (Misc queries) | |||
mergeing cells and wrapping text | Excel Discussion (Misc queries) | |||
Wrapping text in merged cells | Excel Discussion (Misc queries) |