#1   Report Post  
Posted to microsoft.public.excel.misc
Sunny
 
Posts: n/a
Default Column Width

I saw a guy click once to adjust all columns to fit the data. I can't figure
out where he clicked.
  #2   Report Post  
Posted to microsoft.public.excel.misc
TrptDrBarb
 
Posts: n/a
Default Column Width

If you click in the top left corner of the worksheet (which selects of all of
the columns) if you move over to the A column divider (the line between
column A and column B) and double click that line, all of your columns will
adjust to fit.

"Sunny" wrote:

I saw a guy click once to adjust all columns to fit the data. I can't figure
out where he clicked.

  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Column Width

Highlight the columns of interest, then do Format Columns Autofit Selection

Vaya con Dios,
Chuck, CABGx3



"Sunny" wrote:

I saw a guy click once to adjust all columns to fit the data. I can't figure
out where he clicked.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changed column width keeps reverting back to original size David Boone Excel Discussion (Misc queries) 3 May 29th 05 01:22 PM
Is it possible to create one column with two different width? Dave H... Excel Worksheet Functions 1 February 21st 05 05:52 PM
Displaying column width and row height swirlygirl Excel Worksheet Functions 3 February 7th 05 09:53 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM
Column Width Deborah M Excel Discussion (Misc queries) 1 December 6th 04 04:27 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"