Excel Tips - Wrap Text for headings

I am trying to format a page where all employees can access it. I need cells to text werap (I know how to do that) but I need the cell to increase in size as the wrap takes place. I don't want to explain to all the users to enlarge the cells etc. I want it automatic. Any help?

Hello,

I'm trying to figure out how to force text to wrap within a text box in Excel 2007. Note: this is a text box on top of a graph -- nothing to do with cells.

I have tried Insert > Text Box and then typing my text. But contrary to what I have read on line, the default behavior (that I am seeing) is that typed text just ignores the boundaries of the text box, extends infinitely to the right, and doesn't wrap at all (unless I manually insert a carriage return).

How can I force it to wrap within my text box?

Thanks!

Jay

Within a field with the wrap text checked, some of the lines of text do not
wrap properly in the column. How can I correct this? Please help. Thank you.

When I input a large number of text say 1,200 character including spaces the wrap text feature does not show all of the words. It will let me drag the cell selection horizontally, which will eventually show all of the words, but that makes the sheet very wide. It will not fill the box if I drag it vertically.
I have tried all of the cell formatting options, i.e. Alignment Top, Centre bottom, and have justified left, right or middle, but nothing works?

Is there a limit on how much text can be wrapped in a cell?

--
Ritchie

I have several lines of text in one cell in Excel but the text wrap does not
work on all of it. There are just too many instances of needing to use
alt-enter to make it worth doing! Is there a way to get text wrap to actually
work??

Also, why do documents in Excel print differently on different printers or
from different computers? Worksheets look right in print preview but then
come off the printer wrong!

When using Excel, and if the size of the cell is the maximum size in height,
I notice that when entering text, it stops wrapping text after a while. This
is very frustrating, because when i need to print my spreadsheet, I do not
see all my test. Instead, i have to use ALT+Enter to manually shift text to
the next line. This is very frustrating. Any way to fix this?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Dear Friends/Experts,

I have some issue with the excel 2007. Assume i already have some cells with information inside, and i have done the "wrap text" which make the paragraphs look neat in 1 line.

however, when i copy the cell info, and paste into any text editor, it looks to be the original format.

For example...
ORIGINAL
column1
row1 abc
def
row2 123

WRAP
column1
row1 abcdef
row2 123

BUT... after i copy row1 column1 to text editor,

it appears to be

abc
def

any method to solve this? so that it's still in 1 neat line?

Thanks a bunch, urgent help is needed!

Hey Everybody,

I'll copy in my code as it stands so far, then explain my issue:
Code:

Private Sub Worksheet_Activate()

 Worksheets("Labor Report").Range("A2:Z500").Clear
 
 matrow = 1
    
   For pipeinc = 1 To 9
       If Worksheets("Data").Cells(4 + 25 * (pipeinc - 1), 1) <> "" Then
           Worksheets("Labor Report").Cells(matrow, 1) = "Pipe Size: " & Worksheets("Data").Cells(4 + 25 * (pipeinc - 1), 1) & Chr(34)
           Worksheets("Labor Report").Cells(matrow, 1).Font.Bold = True
           matrow = matrow + 1
           Worksheets("Labor Report").Cells(matrow, 1) = "Fitting Name"
           Worksheets("Labor Report").Cells(matrow, 2) = "Quantity"
           Worksheets("Labor Report").Cells(matrow, 1).Font.Bold = True
           Worksheets("Labor Report").Cells(matrow, 2).Font.Bold = True
           matrow = matrow + 1

           For fittinginc = 1 To 22
               If Worksheets("Data").Cells(33 + 7 * (pipeinc - 1), 8 + (fittinginc - 1)) <> "" & Worksheets("Data").Cells(33 + 7 * (pipeinc - 1), 8 + (fittinginc - 1)) <> 0 Then
                   Worksheets("Labor Report").Cells(matrow, 1) = Worksheets("Data").Cells(8 + (fittinginc - 1), 7)
                   Worksheets("Labor Report").Cells(matrow, 2) = Worksheets("Data").Cells(33 + 7 * (pipeinc - 1), 8 + (fittinginc - 1))
                   Worksheets("Labor Report").Cells(matrow, 4) = Worksheets("Data").Cells(33 + 7 * (pipeinc - 1), 8 + (fittinginc - 1))
                   Worksheets("Labor Report").Cells(matrow, 5) = "x " & Worksheets("Data").Cells(34 + 7 * (pipeinc - 1), 8 + (fittinginc - 1))
                   Worksheets("Labor Report").Cells(matrow, 6) = "SubTot = " & Worksheets("Data").Cells(35 + 7 * (pipeinc - 1), 8 + (fittinginc - 1))
                   matrow = matrow + 1
               End If
           Next fittinginc

           Worksheets("Labor Report").Cells(matrow, 6) = "Total = " & Worksheets("Data").Cells(36 + 7 * (pipeinc - 1), 8)

           matrow = matrow + 1

       End If

   Next pipeinc

Worksheets("Labor Report").Cells(matrow + 1, 5) = "Project Total = " & Worksheets("Data").Cells(94, 8)

End Sub

What I'm trying to do is find the appropriate coding to make Excel 2007 VBA wrap the text of the cells I define. AKA Worksheets("Labor Report").Range("A2:A500").Wrap.Text = True. I've tried putting this exact line of code into my worksheet and for some reason it doesn't format the text to wrap in column A. Do I have the formatting of the wrap text wrong? I'm not sure why this isn't working.