software

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.


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:
gt; I want to format a group of adjacent cells to wrap text. I am
gt; highlighting
gt; the cells and then using alignment/wrap text. This does not work so I
gt; am
gt; formatting each cell one by one. There must be a faster way to do
gt; this. Any
gt; assistance would be appreciated.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534825Brilliant! 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.

quot;Bryan Hesseyquot; wrote:

gt;
gt; Selecting a group of cells should (normally) allow you to set the 'wrap'
gt; option within the Format Cells even though items such as dates and
gt; amounts do not wrap.
gt;
gt; Does the problem occur with (say) 3 test cells that you can 'wrap'
gt; individually?
gt;
gt; Do you have some cells that are strangely formatted ?
gt;
gt; --
gt;
gt;
gt; Elizabeth A. Wrote:
gt; gt; I want to format a group of adjacent cells to wrap text. I am
gt; gt; highlighting
gt; gt; the cells and then using alignment/wrap text. This does not work so I
gt; gt; am
gt; gt; formatting each cell one by one. There must be a faster way to do
gt; gt; this. Any
gt; gt; assistance would be appreciated.
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=534825
gt;
gt;


Good to see a resolution, and thanks for the response

--

Elizabeth A. Wrote:
gt; Brilliant! I am wrapping text and it does work with groups of cells.
gt; However I did not see the wrapping because the row heights stayed the
gt; same.
gt; (I know, don't quit my day job.) Thanks, Bryan.
gt;
gt; quot;Bryan Hesseyquot; wrote:
gt;
gt; gt;
gt; gt; Selecting a group of cells should (normally) allow you to set the
gt; 'wrap'
gt; gt; option within the Format Cells even though items such as dates and
gt; gt; amounts do not wrap.
gt; gt;
gt; gt; Does the problem occur with (say) 3 test cells that you can 'wrap'
gt; gt; individually?
gt; gt;
gt; gt; Do you have some cells that are strangely formatted ?
gt; gt;
gt; gt; --
gt; gt;
gt; gt;
gt; gt; Elizabeth A. Wrote:
gt; gt; gt; I want to format a group of adjacent cells to wrap text. I am
gt; gt; gt; highlighting
gt; gt; gt; the cells and then using alignment/wrap text. This does not work
gt; so I
gt; gt; gt; am
gt; gt; gt; formatting each cell one by one. There must be a faster way to do
gt; gt; gt; this. Any
gt; gt; gt; assistance would be appreciated.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=534825
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534825I 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.

quot;Bryan Hesseyquot; wrote:

gt;
gt; Good to see a resolution, and thanks for the response
gt;
gt; --
gt;
gt; Elizabeth A. Wrote:
gt; gt; Brilliant! I am wrapping text and it does work with groups of cells.
gt; gt; However I did not see the wrapping because the row heights stayed the
gt; gt; same.
gt; gt; (I know, don't quit my day job.) Thanks, Bryan.
gt; gt;
gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; Selecting a group of cells should (normally) allow you to set the
gt; gt; 'wrap'
gt; gt; gt; option within the Format Cells even though items such as dates and
gt; gt; gt; amounts do not wrap.
gt; gt; gt;
gt; gt; gt; Does the problem occur with (say) 3 test cells that you can 'wrap'
gt; gt; gt; individually?
gt; gt; gt;
gt; gt; gt; Do you have some cells that are strangely formatted ?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Elizabeth A. Wrote:
gt; gt; gt; gt; I want to format a group of adjacent cells to wrap text. I am
gt; gt; gt; gt; highlighting
gt; gt; gt; gt; the cells and then using alignment/wrap text. This does not work
gt; gt; so I
gt; gt; gt; gt; am
gt; gt; gt; gt; formatting each cell one by one. There must be a faster way to do
gt; gt; gt; gt; this. Any
gt; gt; gt; gt; assistance would be appreciated.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Bryan Hessey
gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; Bryan Hessey's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=534825
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=534825
gt;
gt;

Generally setting wordwrap and rowgt;autofit will do the job to expand the
contents.

If you have manually set the row height, go back into Formatgt;Rowsgt;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. lt;Claudia
gt; wrote:

gt;I read this hoping to get an answer to the row height staying the same. I can
gt;make the text wrap but the cell does not change size with the added text. How
gt;can I make it resize automatically? I know it can be done but don't know how.
gt;Help please.
gt;
gt;quot;Bryan Hesseyquot; wrote:
gt;
gt;gt;
gt;gt; Good to see a resolution, and thanks for the response
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Elizabeth A. Wrote:
gt;gt; gt; Brilliant! I am wrapping text and it does work with groups of cells.
gt;gt; gt; However I did not see the wrapping because the row heights stayed the
gt;gt; gt; same.
gt;gt; gt; (I know, don't quit my day job.) Thanks, Bryan.
gt;gt; gt;
gt;gt; gt; quot;Bryan Hesseyquot; wrote:
gt;gt; gt;
gt;gt; gt; gt;
gt;gt; gt; gt; Selecting a group of cells should (normally) allow you to set the
gt;gt; gt; 'wrap'
gt;gt; gt; gt; option within the Format Cells even though items such as dates and
gt;gt; gt; gt; amounts do not wrap.
gt;gt; gt; gt;
gt;gt; gt; gt; Does the problem occur with (say) 3 test cells that you can 'wrap'
gt;gt; gt; gt; individually?
gt;gt; gt; gt;
gt;gt; gt; gt; Do you have some cells that are strangely formatted ?
gt;gt; gt; gt;
gt;gt; gt; gt; --
gt;gt; gt; gt;
gt;gt; gt; gt;
gt;gt; gt; gt; Elizabeth A. Wrote:
gt;gt; gt; gt; gt; I want to format a group of adjacent cells to wrap text. I am
gt;gt; gt; gt; gt; highlighting
gt;gt; gt; gt; gt; the cells and then using alignment/wrap text. This does not work
gt;gt; gt; so I
gt;gt; gt; gt; gt; am
gt;gt; gt; gt; gt; formatting each cell one by one. There must be a faster way to do
gt;gt; gt; gt; gt; this. Any
gt;gt; gt; gt; gt; assistance would be appreciated.
gt;gt; gt; gt;
gt;gt; gt; gt;
gt;gt; gt; gt; --
gt;gt; gt; gt; Bryan Hessey
gt;gt; gt; gt;
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; gt; Bryan Hessey's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt;gt; gt; gt; View this thread:
gt;gt; gt; www.excelforum.com/showthread...hreadid=534825
gt;gt; gt; gt;
gt;gt; gt; gt;
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Bryan Hessey
gt;gt; ------------------------------------------------------------------------
gt;gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt;gt; View this thread: www.excelforum.com/showthread...hreadid=534825
gt;gt;
gt;gt; 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

quot;Gord Dibbenquot; wrote:

gt; Generally setting wordwrap and rowgt;autofit will do the job to expand the
gt; contents.
gt;
gt; If you have manually set the row height, go back into Formatgt;Rowsgt;Autofit to
gt; reset.
gt;
gt; If you have those two settings enabled but not getting autofit it may be
gt; that you are using merged cells.
gt;
gt; These won't autofit without event code in the worksheet.
gt;
gt; If that's the case, post back if you want the code.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Fri, 2 Jan 2009 12:36:00 -0800, Claudia D. lt;Claudia
gt; gt; wrote:
gt;
gt; gt;I read this hoping to get an answer to the row height staying the same. I can
gt; gt;make the text wrap but the cell does not change size with the added text. How
gt; gt;can I make it resize automatically? I know it can be done but don't know how.
gt; gt;Help please.
gt; gt;
gt; gt;quot;Bryan Hesseyquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; Good to see a resolution, and thanks for the response
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Elizabeth A. Wrote:
gt; gt;gt; gt; Brilliant! I am wrapping text and it does work with groups of cells.
gt; gt;gt; gt; However I did not see the wrapping because the row heights stayed the
gt; gt;gt; gt; same.
gt; gt;gt; gt; (I know, don't quit my day job.) Thanks, Bryan.
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Selecting a group of cells should (normally) allow you to set the
gt; gt;gt; gt; 'wrap'
gt; gt;gt; gt; gt; option within the Format Cells even though items such as dates and
gt; gt;gt; gt; gt; amounts do not wrap.
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Does the problem occur with (say) 3 test cells that you can 'wrap'
gt; gt;gt; gt; gt; individually?
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Do you have some cells that are strangely formatted ?
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; --
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Elizabeth A. Wrote:
gt; gt;gt; gt; gt; gt; I want to format a group of adjacent cells to wrap text. I am
gt; gt;gt; gt; gt; gt; highlighting
gt; gt;gt; gt; gt; gt; the cells and then using alignment/wrap text. This does not work
gt; gt;gt; gt; so I
gt; gt;gt; gt; gt; gt; am
gt; gt;gt; gt; gt; gt; formatting each cell one by one. There must be a faster way to do
gt; gt;gt; gt; gt; gt; this. Any
gt; gt;gt; gt; gt; gt; assistance would be appreciated.
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; --
gt; gt;gt; gt; gt; Bryan Hessey
gt; gt;gt; gt; gt;
gt; gt;gt; gt; ------------------------------------------------------------------------
gt; gt;gt; gt; gt; Bryan Hessey's Profile:
gt; gt;gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt;gt; gt; gt; View this thread:
gt; gt;gt; gt; www.excelforum.com/showthread...hreadid=534825
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Bryan Hessey
gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; gt;gt; View this thread: www.excelforum.com/showthread...hreadid=534825
gt; gt;gt;
gt; gt;gt;
gt;
gt;

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.

groups.google.com/group/micro...1c160cbeb27874

If no merged cells, the regular wraptext and rowgt;autofit should work OKGordOn Wed, 21 Jan 2009 06:03:01 -0800, Langrg
gt; wrote:

gt;I would like the code, since I am trying to do a similiar task. Using VB6 to
gt;programmatically set a cell to wrap text and autofit as I create the
gt;spreadsheet.
gt;
gt;Thanks,
gt;
gt;Dick Lang
gt;
gt;quot;Gord Dibbenquot; wrote:
gt;
gt;gt; Generally setting wordwrap and rowgt;autofit will do the job to expand the
gt;gt; contents.
gt;gt;
gt;gt; If you have manually set the row height, go back into Formatgt;Rowsgt;Autofit to
gt;gt; reset.
gt;gt;
gt;gt; If you have those two settings enabled but not getting autofit it may be
gt;gt; that you are using merged cells.
gt;gt;
gt;gt; These won't autofit without event code in the worksheet.
gt;gt;
gt;gt; If that's the case, post back if you want the code.
gt;gt;
gt;gt;
gt;gt; Gord Dibben MS Excel MVP
gt;gt;
gt;gt; On Fri, 2 Jan 2009 12:36:00 -0800, Claudia D. lt;Claudia
gt;gt; gt; wrote:
gt;gt;
gt;gt; gt;I read this hoping to get an answer to the row height staying the same. I can
gt;gt; gt;make the text wrap but the cell does not change size with the added text. How
gt;gt; gt;can I make it resize automatically? I know it can be done but don't know how.
gt;gt; gt;Help please.
gt;gt; gt;
gt;gt; gt;quot;Bryan Hesseyquot; wrote:
gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt; Good to see a resolution, and thanks for the response
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt;
gt;gt; gt;gt; Elizabeth A. Wrote:
gt;gt; gt;gt; gt; Brilliant! I am wrapping text and it does work with groups of cells.
gt;gt; gt;gt; gt; However I did not see the wrapping because the row heights stayed the
gt;gt; gt;gt; gt; same.
gt;gt; gt;gt; gt; (I know, don't quit my day job.) Thanks, Bryan.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Bryan Hesseyquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; Selecting a group of cells should (normally) allow you to set the
gt;gt; gt;gt; gt; 'wrap'
gt;gt; gt;gt; gt; gt; option within the Format Cells even though items such as dates and
gt;gt; gt;gt; gt; gt; amounts do not wrap.
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; Does the problem occur with (say) 3 test cells that you can 'wrap'
gt;gt; gt;gt; gt; gt; individually?
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; Do you have some cells that are strangely formatted ?
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; --
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; Elizabeth A. Wrote:
gt;gt; gt;gt; gt; gt; gt; I want to format a group of adjacent cells to wrap text. I am
gt;gt; gt;gt; gt; gt; gt; highlighting
gt;gt; gt;gt; gt; gt; gt; the cells and then using alignment/wrap text. This does not work
gt;gt; gt;gt; gt; so I
gt;gt; gt;gt; gt; gt; gt; am
gt;gt; gt;gt; gt; gt; gt; formatting each cell one by one. There must be a faster way to do
gt;gt; gt;gt; gt; gt; gt; this. Any
gt;gt; gt;gt; gt; gt; gt; assistance would be appreciated.
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; --
gt;gt; gt;gt; gt; gt; Bryan Hessey
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt;gt; gt; gt; Bryan Hessey's Profile:
gt;gt; gt;gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt;gt; gt;gt; gt; gt; View this thread:
gt;gt; gt;gt; gt; www.excelforum.com/showthread...hreadid=534825
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Bryan Hessey
gt;gt; gt;gt; ------------------------------------------------------------------------
gt;gt; gt;gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt;gt; gt;gt; View this thread: www.excelforum.com/showthread...hreadid=534825
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt; 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-gt;-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 quot;Gord Dibbenquot; wrote:

gt; Are you using merged cells?
gt;
gt; If so, code by Greg Wilson can be found here.............
gt;
gt; Watch out for word wrap in the URL which is all one line.
gt;
gt; groups.google.com/group/micro...1c160cbeb27874
gt;
gt; If no merged cells, the regular wraptext and rowgt;autofit should work OK
gt;
gt;
gt; Gord
gt;
gt;
gt; On Wed, 21 Jan 2009 06:03:01 -0800, Langrg
gt; gt; wrote:
gt;
gt; gt;I would like the code, since I am trying to do a similiar task. Using VB6 to
gt; gt;programmatically set a cell to wrap text and autofit as I create the
gt; gt;spreadsheet.
gt; gt;
gt; gt;Thanks,
gt; gt;
gt; gt;Dick Lang
gt; gt;
gt; gt;quot;Gord Dibbenquot; wrote:
gt; gt;
gt; gt;gt; Generally setting wordwrap and rowgt;autofit will do the job to expand the
gt; gt;gt; contents.
gt; gt;gt;
gt; gt;gt; If you have manually set the row height, go back into Formatgt;Rowsgt;Autofit to
gt; gt;gt; reset.
gt; gt;gt;
gt; gt;gt; If you have those two settings enabled but not getting autofit it may be
gt; gt;gt; that you are using merged cells.
gt; gt;gt;
gt; gt;gt; These won't autofit without event code in the worksheet.
gt; gt;gt;
gt; gt;gt; If that's the case, post back if you want the code.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; Gord Dibben MS Excel MVP
gt; gt;gt;
gt; gt;gt; On Fri, 2 Jan 2009 12:36:00 -0800, Claudia D. lt;Claudia
gt; gt;gt; gt; wrote:
gt; gt;gt;
gt; gt;gt; gt;I read this hoping to get an answer to the row height staying the same. I can
gt; gt;gt; gt;make the text wrap but the cell does not change size with the added text. How
gt; gt;gt; gt;can I make it resize automatically? I know it can be done but don't know how.
gt; gt;gt; gt;Help please.
gt; gt;gt; gt;
gt; gt;gt; gt;quot;Bryan Hesseyquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Good to see a resolution, and thanks for the response
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Elizabeth A. Wrote:
gt; gt;gt; gt;gt; gt; Brilliant! I am wrapping text and it does work with groups of cells.
gt; gt;gt; gt;gt; gt; However I did not see the wrapping because the row heights stayed the
gt; gt;gt; gt;gt; gt; same.
gt; gt;gt; gt;gt; gt; (I know, don't quit my day job.) Thanks, Bryan.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; Selecting a group of cells should (normally) allow you to set the
gt; gt;gt; gt;gt; gt; 'wrap'
gt; gt;gt; gt;gt; gt; gt; option within the Format Cells even though items such as dates and
gt; gt;gt; gt;gt; gt; gt; amounts do not wrap.
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; Does the problem occur with (say) 3 test cells that you can 'wrap'
gt; gt;gt; gt;gt; gt; gt; individually?
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; Do you have some cells that are strangely formatted ?
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; --
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; Elizabeth A. Wrote:
gt; gt;gt; gt;gt; gt; gt; gt; I want to format a group of adjacent cells to wrap text. I am
gt; gt;gt; gt;gt; gt; gt; gt; highlighting
gt; gt;gt; gt;gt; gt; gt; gt; the cells and then using alignment/wrap text. This does not work
gt; gt;gt; gt;gt; gt; so I
gt; gt;gt; gt;gt; gt; gt; gt; am
gt; gt;gt; gt;gt; gt; gt; gt; formatting each cell one by one. There must be a faster way to do
gt; gt;gt; gt;gt; gt; gt; gt; this. Any
gt; gt;gt; gt;gt; gt; gt; gt; assistance would be appreciated.
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; --
gt; gt;gt; gt;gt; gt; gt; Bryan Hessey
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; ------------------------------------------------------------------------
gt; gt;gt; gt;gt; gt; gt; Bryan Hessey's Profile:
gt; gt;gt; gt;gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt;gt; gt;gt; gt; gt; View this thread:
gt; gt;gt; gt;gt; gt; www.excelforum.com/showthread...hreadid=534825
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt; Bryan Hessey
gt; gt;gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; gt;gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; gt;gt; gt;gt; View this thread: www.excelforum.com/showthread...hreadid=534825
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;

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 amp; Cell2 amp; Cell3 amp; Cell4 entered in a cell not within that range.Gord Dibben MS Excel MVPOn Wed, 19 Aug 2009 21:48:01 -0700, Asad gt;
wrote:

gt;Hi,
gt;Let say, there are four cells together in one column and all have some text
gt;in them. If I select all cells and do Home-gt;-Wrap Text. The first cell's text
gt;remain and other three cell's text deleted itself. But I want to combine the
gt;text of all four cells in first cell. Please guide me.
gt;
gt;Thanks in advance.
gt;
gt;Asad
gt;
gt;
gt;
gt;
gt;
gt;quot;Gord Dibbenquot; wrote:
gt;
gt;gt; Are you using merged cells?
gt;gt;
gt;gt; If so, code by Greg Wilson can be found here.............
gt;gt;
gt;gt; Watch out for word wrap in the URL which is all one line.
gt;gt;
gt;gt; groups.google.com/group/micro...1c160cbeb27874
gt;gt;
gt;gt; If no merged cells, the regular wraptext and rowgt;autofit should work OK
gt;gt;
gt;gt;
gt;gt; Gord
gt;gt;
gt;gt;
gt;gt; On Wed, 21 Jan 2009 06:03:01 -0800, Langrg
gt;gt; gt; wrote:
gt;gt;
gt;gt; gt;I would like the code, since I am trying to do a similiar task. Using VB6 to
gt;gt; gt;programmatically set a cell to wrap text and autofit as I create the
gt;gt; gt;spreadsheet.
gt;gt; gt;
gt;gt; gt;Thanks,
gt;gt; gt;
gt;gt; gt;Dick Lang
gt;gt; gt;
gt;gt; gt;quot;Gord Dibbenquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Generally setting wordwrap and rowgt;autofit will do the job to expand the
gt;gt; gt;gt; contents.
gt;gt; gt;gt;
gt;gt; gt;gt; If you have manually set the row height, go back into Formatgt;Rowsgt;Autofit to
gt;gt; gt;gt; reset.
gt;gt; gt;gt;
gt;gt; gt;gt; If you have those two settings enabled but not getting autofit it may be
gt;gt; gt;gt; that you are using merged cells.
gt;gt; gt;gt;
gt;gt; gt;gt; These won't autofit without event code in the worksheet.
gt;gt; gt;gt;
gt;gt; gt;gt; If that's the case, post back if you want the code.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; Gord Dibben MS Excel MVP
gt;gt; gt;gt;
gt;gt; gt;gt; On Fri, 2 Jan 2009 12:36:00 -0800, Claudia D. lt;Claudia
gt;gt; gt;gt; gt; wrote:
gt;gt; gt;gt;
gt;gt; gt;gt; gt;I read this hoping to get an answer to the row height staying the same. I can
gt;gt; gt;gt; gt;make the text wrap but the cell does not change size with the added text. How
gt;gt; gt;gt; gt;can I make it resize automatically? I know it can be done but don't know how.
gt;gt; gt;gt; gt;Help please.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;quot;Bryan Hesseyquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Good to see a resolution, and thanks for the response
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; --
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Elizabeth A. Wrote:
gt;gt; gt;gt; gt;gt; gt; Brilliant! I am wrapping text and it does work with groups of cells.
gt;gt; gt;gt; gt;gt; gt; However I did not see the wrapping because the row heights stayed the
gt;gt; gt;gt; gt;gt; gt; same.
gt;gt; gt;gt; gt;gt; gt; (I know, don't quit my day job.) Thanks, Bryan.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; quot;Bryan Hesseyquot; wrote:
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt; Selecting a group of cells should (normally) allow you to set the
gt;gt; gt;gt; gt;gt; gt; 'wrap'
gt;gt; gt;gt; gt;gt; gt; gt; option within the Format Cells even though items such as dates and
gt;gt; gt;gt; gt;gt; gt; gt; amounts do not wrap.
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt; Does the problem occur with (say) 3 test cells that you can 'wrap'
gt;gt; gt;gt; gt;gt; gt; gt; individually?
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt; Do you have some cells that are strangely formatted ?
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt; --
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt; Elizabeth A. Wrote:
gt;gt; gt;gt; gt;gt; gt; gt; gt; I want to format a group of adjacent cells to wrap text. I am
gt;gt; gt;gt; gt;gt; gt; gt; gt; highlighting
gt;gt; gt;gt; gt;gt; gt; gt; gt; the cells and then using alignment/wrap text. This does not work
gt;gt; gt;gt; gt;gt; gt; so I
gt;gt; gt;gt; gt;gt; gt; gt; gt; am
gt;gt; gt;gt; gt;gt; gt; gt; gt; formatting each cell one by one. There must be a faster way to do
gt;gt; gt;gt; gt;gt; gt; gt; gt; this. Any
gt;gt; gt;gt; gt;gt; gt; gt; gt; assistance would be appreciated.
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt; --
gt;gt; gt;gt; gt;gt; gt; gt; Bryan Hessey
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt;gt; gt;gt; gt; gt; Bryan Hessey's Profile:
gt;gt; gt;gt; gt;gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt;gt; gt;gt; gt;gt; gt; gt; View this thread:
gt;gt; gt;gt; gt;gt; gt; www.excelforum.com/showthread...hreadid=534825
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; --
gt;gt; gt;gt; gt;gt; Bryan Hessey
gt;gt; gt;gt; gt;gt; ------------------------------------------------------------------------
gt;gt; gt;gt; gt;gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt;gt; gt;gt; gt;gt; View this thread: www.excelforum.com/showthread...hreadid=534825
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;