Wow! We sure do have somesmart and tallented folks on this list.


If you just need to auto fit a single column instead of the entire sheet do
the following:

Locate the cell with the largest amount of data in it.
click on it  (I am a high partial) smile

alt O to choose format menu
arrow down to column
and choose auto fit selection

This will fit the column to the largest entry in that column without
reformatting the entire sheet.

Safe computing to you.



----- Original Message -----
From: "Catherine Getchell" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Wednesday, October 19, 2005 8:02 PM
Subject: Re: 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
:
:
:
: --
: No virus found in this incoming message.
: Checked by AVG Anti-Virus.
: Version: 7.0.344 / Virus Database: 267.12.4/142 - Release Date: 10/18/2005
:
:


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