| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I wrap text in more than one cell at a time?
I want to format a group of adjacent cells to wrap text. I am highlighting
the cells and then using alignment/wrap text. This does not work so I am formatting each cell one by one. There must be a faster way to do this. Any assistance would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I wrap text in more than one cell at a time?
Selecting a group of cells should (normally) allow you to set the 'wrap' option within the Format Cells even though items such as dates and amounts do not wrap. Does the problem occur with (say) 3 test cells that you can 'wrap' individually? Do you have some cells that are strangely formatted ? -- Elizabeth A. Wrote: I want to format a group of adjacent cells to wrap text. I am highlighting the cells and then using alignment/wrap text. This does not work so I am formatting each cell one by one. There must be a faster way to do this. Any assistance would be appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534825 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I wrap text in more than one cell at a time?
Brilliant! I am wrapping text and it does work with groups of cells.
However I did not see the wrapping because the row heights stayed the same. (I know, don't quit my day job.) Thanks, Bryan. "Bryan Hessey" wrote: Selecting a group of cells should (normally) allow you to set the 'wrap' option within the Format Cells even though items such as dates and amounts do not wrap. Does the problem occur with (say) 3 test cells that you can 'wrap' individually? Do you have some cells that are strangely formatted ? -- Elizabeth A. Wrote: I want to format a group of adjacent cells to wrap text. I am highlighting the cells and then using alignment/wrap text. This does not work so I am formatting each cell one by one. There must be a faster way to do this. Any assistance would be appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534825 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I wrap text in more than one cell at a time?
Good to see a resolution, and thanks for the response -- Elizabeth A. Wrote: Brilliant! I am wrapping text and it does work with groups of cells. However I did not see the wrapping because the row heights stayed the same. (I know, don't quit my day job.) Thanks, Bryan. "Bryan Hessey" wrote: Selecting a group of cells should (normally) allow you to set the 'wrap' option within the Format Cells even though items such as dates and amounts do not wrap. Does the problem occur with (say) 3 test cells that you can 'wrap' individually? Do you have some cells that are strangely formatted ? -- Elizabeth A. Wrote: I want to format a group of adjacent cells to wrap text. I am highlighting the cells and then using alignment/wrap text. This does not work so I am formatting each cell one by one. There must be a faster way to do this. Any assistance would be appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534825 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534825 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I wrap text in more than one cell at a time?
I read this hoping to get an answer to the row height staying the same. I can
make the text wrap but the cell does not change size with the added text. How can I make it resize automatically? I know it can be done but don't know how. Help please. "Bryan Hessey" wrote: Good to see a resolution, and thanks for the response -- Elizabeth A. Wrote: Brilliant! I am wrapping text and it does work with groups of cells. However I did not see the wrapping because the row heights stayed the same. (I know, don't quit my day job.) Thanks, Bryan. "Bryan Hessey" wrote: Selecting a group of cells should (normally) allow you to set the 'wrap' option within the Format Cells even though items such as dates and amounts do not wrap. Does the problem occur with (say) 3 test cells that you can 'wrap' individually? Do you have some cells that are strangely formatted ? -- Elizabeth A. Wrote: I want to format a group of adjacent cells to wrap text. I am highlighting the cells and then using alignment/wrap text. This does not work so I am formatting each cell one by one. There must be a faster way to do this. Any assistance would be appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534825 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534825 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I wrap text in more than one cell at a time?
Generally setting wordwrap and rowautofit will do the job to expand the
contents. If you have manually set the row height, go back into FormatRowsAutofit to reset. If you have those two settings enabled but not getting autofit it may be that you are using merged cells. These won't autofit without event code in the worksheet. If that's the case, post back if you want the code. Gord Dibben MS Excel MVP On Fri, 2 Jan 2009 12:36:00 -0800, Claudia D. <Claudia wrote: I read this hoping to get an answer to the row height staying the same. I can make the text wrap but the cell does not change size with the added text. How can I make it resize automatically? I know it can be done but don't know how. Help please. "Bryan Hessey" wrote: Good to see a resolution, and thanks for the response -- Elizabeth A. Wrote: Brilliant! I am wrapping text and it does work with groups of cells. However I did not see the wrapping because the row heights stayed the same. (I know, don't quit my day job.) Thanks, Bryan. "Bryan Hessey" wrote: Selecting a group of cells should (normally) allow you to set the 'wrap' option within the Format Cells even though items such as dates and amounts do not wrap. Does the problem occur with (say) 3 test cells that you can 'wrap' individually? Do you have some cells that are strangely formatted ? -- Elizabeth A. Wrote: I want to format a group of adjacent cells to wrap text. I am highlighting the cells and then using alignment/wrap text. This does not work so I am formatting each cell one by one. There must be a faster way to do this. Any assistance would be appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534825 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534825 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why am I getting XXX error in text cell with word wrap turned on? | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| how many lines can be in wrap text within a cell? | Excel Worksheet Functions | |||
| how many lines can be in wrap text within a cell? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
