adjusting columns in multiple worksheets of workbook with one step

[carole]

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.

[Mallycat]

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

yep.

1. Select all the sheets you want to change by using Shift (or Control) and selecting all the sheet tabs.
2. Then click in the square between the A and the 1 in the top left hand corner of the active sheet. 3
3. move your mouse between any 2 columns on the active sheet and double click.
4. Right click on the tabs and select ungroup.

Matt

[Gord Dibben]

Select first worksheet.

SHIFT + Click on last worksheet tab.

This groups the sheets.

Select some columns or all columns on the active sheet.

Format>Column>Autofit.

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
<[email protected]> 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.