|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Are you using merged cells?
If so, code by Greg Wilson can be found here.............
Watch out for word wrap in the URL which is all one line.
http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/2293ac4e6373c4d3/ca1c160cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874
If no merged cells, the regular wraptext and row>autofit should work OK
Gord
On Wed, 21 Jan 2009 06:03:01 -0800, Langrg
<Langrg@discussions.microsoft.com> wrote:
>I would like the code, since I am trying to do a similiar task. Using VB6 to
>programmatically set a cell to wrap text and autofit as I create the
>spreadsheet.
>
>Thanks,
>
>Dick Lang
>
>"Gord Dibben" wrote:
>
>> Generally setting wordwrap and row>autofit will do the job to expand the
>> contents.
>>
>> If you have manually set the row height, go back into Format>Rows>Autofit 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
>> D.@discussions.microsoft.com> 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?action=getinfo&userid=21059
>> >> > > View this thread:
>> >> > http://www.excelforum.com/showthread.php?threadid=534825
>> >> > >
>> >> > >
>> >>
>> >>
>> >> --
>> >> Bryan Hessey
>> >> ------------------------------------------------------------------------
>> >> Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
>> >> View this thread: http://www.excelforum.com/showthread.php?threadid=534825
>> >>
>> >>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
Hi,
Let say, there are four cells together in one column and all have some text
in them. If I select all cells and do Home->-Wrap Text. The first cell's text
remain and other three cell's text deleted itself. But I want to combine the
text of all four cells in first cell. Please guide me.
Thanks in advance.
Asad
"Gord Dibben" wrote:
> Are you using merged cells?
>
> If so, code by Greg Wilson can be found here.............
>
> Watch out for word wrap in the URL which is all one line.
>
> http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/2293ac4e6373c4d3/ca1c160cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874
>
> If no merged cells, the regular wraptext and row>autofit should work OK
>
>
> Gord
>
>
> On Wed, 21 Jan 2009 06:03:01 -0800, Langrg
> <Langrg@discussions.microsoft.com> wrote:
>
> >I would like the code, since I am trying to do a similiar task. Using VB6 to
> >programmatically set a cell to wrap text and autofit as I create the
> >spreadsheet.
> >
> >Thanks,
> >
> >Dick Lang
> >
> >"Gord Dibben" wrote:
> >
> >> Generally setting wordwrap and row>autofit will do the job to expand the
> >> contents.
> >>
> >> If you have manually set the row height, go back into Format>Rows>Autofit 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
> >> D.@discussions.microsoft.com> 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?action=getinfo&userid=21059
> >> >> > > View this thread:
> >> >> > http://www.excelforum.com/showthread.php?threadid=534825
> >> >> > >
> >> >> > >
> >> >>
> >> >>
> >> >> --
> >> >> Bryan Hessey
> >> >> ------------------------------------------------------------------------
> >> >> Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
> >> >> View this thread: http://www.excelforum.com/showthread.php?threadid=534825
> >> >>
> >> >>
> >>
> >>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
If you are losing text from all but the top left cell then you are not
clicking on Wrap Text.
You are clicking Merge and Center................which takes the value from
one cell only and warns you that this will happen.
To have the text from 4 cells into one..............
=Cell1 & Cell2 & Cell3 & Cell4 entered in a cell not within that range.
Gord Dibben MS Excel MVP
On Wed, 19 Aug 2009 21:48:01 -0700, Asad <Asad@discussions.microsoft.com>
wrote:
>Hi,
>Let say, there are four cells together in one column and all have some text
>in them. If I select all cells and do Home->-Wrap Text. The first cell's text
>remain and other three cell's text deleted itself. But I want to combine the
>text of all four cells in first cell. Please guide me.
>
>Thanks in advance.
>
>Asad
>
>
>
>
>
>"Gord Dibben" wrote:
>
>> Are you using merged cells?
>>
>> If so, code by Greg Wilson can be found here.............
>>
>> Watch out for word wrap in the URL which is all one line.
>>
>> http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/2293ac4e6373c4d3/ca1c160cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874
>>
>> If no merged cells, the regular wraptext and row>autofit should work OK
>>
>>
>> Gord
>>
>>
>> On Wed, 21 Jan 2009 06:03:01 -0800, Langrg
>> <Langrg@discussions.microsoft.com> wrote:
>>
>> >I would like the code, since I am trying to do a similiar task. Using VB6 to
>> >programmatically set a cell to wrap text and autofit as I create the
>> >spreadsheet.
>> >
>> >Thanks,
>> >
>> >Dick Lang
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> Generally setting wordwrap and row>autofit will do the job to expand the
>> >> contents.
>> >>
>> >> If you have manually set the row height, go back into Format>Rows>Autofit 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
>> >> D.@discussions.microsoft.com> 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?action=getinfo&userid=21059
>> >> >> > > View this thread:
>> >> >> > http://www.excelforum.com/showthread.php?threadid=534825
>> >> >> > >
>> >> >> > >
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bryan Hessey
>> >> >> ------------------------------------------------------------------------
>> >> >> Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
>> >> >> View this thread: http://www.excelforum.com/showthread.php?threadid=534825
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Answer
Notify me of replies