In addition to the autofit suggestion, there is another
alternative which may be worth considering where varying
lengths of text are required in a cell, resulting in columns
being too wide.  However the following is not recommended
for numerical values for obvious reasons.

Highlight the column, then from the Format menu, select
"Cells".  There are six tabs in the Format Cells dialog.
Select the "Alignment" one.  Go down to the "Text Control"
section, and check the "Wrap Text" box.  This will increase
the height some rows where there is a lot of text in a cell,
but at least the text will all be shown.

I would hesitate to suggest checking, "Shrink to fit", since
this can result in the text ending up being microscopic in
size.

George.

-----Original Message-----
From: VICUG-L: Visually Impaired Computer Users' Group List
[mailto:[log in to unmask]] On Behalf Of
Catherine Getchell
Sent: Thursday, October 20, 2005 1:02 AM
To: [log in to unmask]
Subject: Re: [VICUG-L] Excel question:

Hi,
Here's another way to solve this problem, at least I think
it will solve it.
Select your entire excel document with a control-a.  Then go
into your format menu and select columns.  Then click on
autofit selection.  All your text should make it into the
cell.  You may have to print in landscape format rather than
portrait if you have a lot of columns to fit on the page.
Or a sighted person can look at the print preview option
with you to help you determine the best way to print your
table so that it makes sense visually and is easy to read.
I've had this problem before with excel myself, so I know
what you're dealing with. Good luck with it.
Catherine Getchell
----- Original Message -----
From: "severine" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Tuesday, October 18, 2005 3:26 AM
Subject: Excel question:


> Hi listers,
> Could someone tell me how to adjust the width of
particular cells to = 
> their contents? I use Excel XP 2003 (at least, I think so
but I 
> couldn't = find the version info, somehow.) I have to
print out some 
> excel files where some cells contain text. = Often, my
colleagues tell 
> me afterwards that part of the text is = missing. The
template file 
> where I must fill in the data is not very = well made, I
think because 
> the info is not in adjacent cells, and some = cells in one
column 
> should be much wider than others in the same column. = Is
there a way 
> to tell the program to print out all the text, even if =
that messes 
> up the table aspect of the spreadsheet? Or must I just =
rewrite the 
> whole template and if so, could you please give me tips on
= how to do 
> so, knowing that anyhow, some lines will have to contain
more = text 
> than others.
> Thanks a lot for any info, I hope I can achieve proper
results without 
> = having to spend too much time on it, although I know
good templates 
> are = worth spending some time upon.
>
> A great day to everyone,
> S=E9verine
>
>
> VICUG-L is the Visually Impaired Computer User Group List.
> To join or leave the list, send a message to 
> [log in to unmask]  In the body of the
message, simply 
> type "subscribe vicug-l" or "unsubscribe vicug-l" without
the quotations.
> VICUG-L is archived on the World Wide Web at 
> http://maelstrom.stjohns.edu/archives/vicug-l.html
>
>


VICUG-L is the Visually Impaired Computer User Group List.
To join or leave the list, send a message to
[log in to unmask]  In the body of the message,
simply type "subscribe vicug-l" or "unsubscribe vicug-l"
without the quotations.
 VICUG-L is archived on the World Wide Web at
http://maelstrom.stjohns.edu/archives/vicug-l.html


VICUG-L is the Visually Impaired Computer User Group List.
To join or leave the list, send a message to
[log in to unmask]  In the body of the message, simply type
"subscribe vicug-l" or "unsubscribe vicug-l" without the quotations.
 VICUG-L is archived on the World Wide Web at
http://maelstrom.stjohns.edu/archives/vicug-l.html