Columns in Excel with autofit

  • From: "Chris Chaffin" <chaffin@xxxxxxxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Sat, 24 Apr 2004 23:09:06 -0400

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

Other related posts: