Select first worksheet.

SHIFT + Click on last worksheet tab.

This groups the sheets.

Select some columns or all columns on the active sheet.

FormatColumnAutofit.

Will be done to all sheets.

IMPORTANT.......Do not forget to ungroup the sheets by right-click on a tab and
"Ungroup" or just click on any tab other than the active sheet tab.

While in group mode, what you do to one sheet will be done to all.


Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 20:52:21 -0500, carole
wrote:


can someone tell me if there is a way to adjust columns of many
worksheets in a workbook to fit the numbers contained in the columns,
using one step instead of adjusting each worksheet individually. The
numbers in each worksheet would have a different amount of figures. I
am thinking of something like a global autofit maybe. Is there a way to
do this that someone can tell me about. This would save me hundreds of
steps.
Thank you.