Re: Columns in Excel with autofit
- From: "Julie Warrington" <jdwtlc@xxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Mon, 26 Apr 2004 13:05:36 -0700
It will choose the size by the largest in each column.
----- Original Message -----
From: "Chris Chaffin" <chaffin@xxxxxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Monday, April 26, 2004 12:09 PM
Subject: Re: Columns in Excel with autofit
> Hi,
> I usually do this by column, but I like your way of selecting the entire
> workbook at one time. I just have one question,
> will it make all the cells in the worksheet the size of the largest cell
in
> the worksheet?
> or,
> does it size each cell in each column by the largest cell in each column?
> Thanks in advance,
> Chris Chaffin
>
>
>
> ----- Original Message -----
> From: "Julie Warrington" <jdwtlc@xxxxxxx>
> To: <jfw@xxxxxxxxxxxxx>
> Sent: Monday, April 26, 2004 12:09 PM
> Subject: Re: Columns in Excel with autofit
>
>
> > I agree, and if you would rather not worry about doing one column at a
> time,
> > you can control A to highlight all, and auto fit the same way and it
will
> > widen all columns to the longest in the column. This is the simplest in
> my
> > mind also.
> > ----- Original Message -----
> > From: "Chris Chaffin" <chaffin@xxxxxxxxxxxxxx>
> > To: <jfw@xxxxxxxxxxxxx>
> > Sent: Saturday, April 24, 2004 8:09 PM
> > Subject: Columns in Excel with autofit
> >
> >
> > > Hi all,
> > > When using auto fit within Excel, if I select the entire column, it
> widens
> > the entire column to the width of the cell with the most information. I
> > just tried it again in Excel to re confirm this. For example, if I was
> auto
> > fitting column B, and I was sitting on cell B1. Lets say cell B5 has
the
> > most information in it. I select the entire column with control+space
> bar.
> > Alt+O for the format menu, arrow down to column, right arrow to the
> submenu,
> > arrow down to auto fit, and hit enter. Excel will widen the entire
column
> > to fit the information in cell B5, which is the cell within that column
> with
> > the most information, even though I am sitting in cell B1.
> > > Hope this helps,
> > > Chris Chaffin
> > > --
> > > To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> > > To unsubscribe from this mailing list, send a message to
> > jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> > > Archives located at: //www.freelists.org/archives/jfw
> > >
> > > If you have any concerns about the list, post received from the list,
or
> > the way the list is being run, do not post them to the list. Rather
> contact
> > the list owner at jfw-admins@xxxxxxxxxxxxxx
> > >
> >
> >
> > --
> > To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> > To unsubscribe from this mailing list, send a message to
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> > Archives located at: //www.freelists.org/archives/jfw
> >
> > If you have any concerns about the list, post received from the list, or
> the way the list is being run, do not post them to the list. Rather
contact
> the list owner at jfw-admins@xxxxxxxxxxxxxx
>
> --
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> Archives located at: //www.freelists.org/archives/jfw
>
> If you have any concerns about the list, post received from the list, or
the way the list is being run, do not post them to the list. Rather contact
the list owner at jfw-admins@xxxxxxxxxxxxxx
>
--
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
