software

Hi. I wonder if you can help me? I am trying to print out an excel
spreadsheet but am having trouble with getting text to fit within
different cells.

I have over 1000 rows of data, mainly text, and it goes across 8
columns. The first three columns are the widest, and I have selected
for the text to wrap around in cell alignment because some of the text
is a lot longer that I want the width of the columns to be, so I am
not bothered about the odd few lines with text wrapping and making
some rows bigger.

The problem I have is that when I am viewing or printing out the
information, the rows with text that needs to wrap it is not
displaying all the text, it is cutting it off and hiding it so I can't
see it, and it isn't all printed.

How do I go about fixing this? I could spend ages fixing all the lines
that have text that is supposed to wrap and make all those rows bigger
in height so it fits in, but there must be a quick way to fix this? It
seems very temperamental trying to get it exactly how you want it.

I am using Excel 2000 on XP Pro BTW.

Cheers

John
Select the columns, then from the menu bar click Format / Row / Autofit.

John

quot;Johnquot; gt; wrote in message
...
gt; Hi. I wonder if you can help me? I am trying to print out an excel
gt; spreadsheet but am having trouble with getting text to fit within
gt; different cells.
gt;
gt; I have over 1000 rows of data, mainly text, and it goes across 8
gt; columns. The first three columns are the widest, and I have selected
gt; for the text to wrap around in cell alignment because some of the text
gt; is a lot longer that I want the width of the columns to be, so I am
gt; not bothered about the odd few lines with text wrapping and making
gt; some rows bigger.
gt;
gt; The problem I have is that when I am viewing or printing out the
gt; information, the rows with text that needs to wrap it is not
gt; displaying all the text, it is cutting it off and hiding it so I can't
gt; see it, and it isn't all printed.
gt;
gt; How do I go about fixing this? I could spend ages fixing all the lines
gt; that have text that is supposed to wrap and make all those rows bigger
gt; in height so it fits in, but there must be a quick way to fix this? It
gt; seems very temperamental trying to get it exactly how you want it.
gt;
gt; I am using Excel 2000 on XP Pro BTW.
gt;
gt; Cheers
gt;
gt; John
gt;
gt;