i am having issues with a report in excel. the formatting of the sheet makes it so some of the columns do not display all of the data (ie not autofitted) and the sheet contains 31 pages. is there a way to set by default all columns to always auto-fit in excel... or do i have to select each column on each sheet and go to format -> column -> autofit.

thx

Re: Excel question - autofit

Hmmm, I kinda know what you are talking about. I know if you double click the part on the column that will let you expand or close the width of the column it will auto fit. This will make it a little quicker but I am sure there is another way.:what

Re: Excel question - autofit

Hit Ctrl A to select all the data and THEN do what he said i.e.

[quote=losehlertx13;394728]double click the part on the column that will let you expand or close the width of the column it will auto fit. This will make it a little quicker but I am sure there is another way.:what[/quote]

See attached,

that will auto expand the width of the cells to fit the data posted in the largest cell

Re: Excel question - autofit

right i knew that... but it still involves going through each sheet of the spreadsheet and doing that... is there not a setting that will make it automatic?

thanks for the quick answers guys

Re: Excel question - autofit

wait, you said 31 pages or 31 worksheets ? If its worksheets, do the following

• click on the first worksheet (tab at the bottom),
• Press and hold the shift key
• then click on the last work sheet (all the time keeping the shift key depressed).
• All worksheets should now be selected.
• Then do the above

If that doesnt work, do all the above except for the last step, do Format >> Rows >> Autofit

Re: Excel question - autofit

i'll give that a go, thanks mate

Re: Excel question - autofit

if you select all sheets than do ctrl A in one of them, you'll select all cells of all sheets. then do click right and select "format cell" select alignment then "wrap text" you can also center horizontal or vertical cheers

Re: Excel question - autofit

you can also make a macro to run at specified events to do this, and can save it globally or only for the spreadsheet (in case it's pulling from an ODBC source or something). events like any time a cell is changed, etc

Re: Excel question - autofit

geek

Re: Excel question - autofit

[quote=Kamal;394923]geek[/quote]

LOL, I'm guessing accountant geek which is like 3 times worse. (I kid, I kid).

Re: Excel question - autofit

^^^ they call that a Sean :D