adjusting columns in multiple worksheets of workbook with one step
 

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.


--
carole
------------------------------------------------------------------------
carole's Profile: http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=559551

adjusting columns in multiple worksheets of workbook with one step
 

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

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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=559551

adjusting columns in multiple worksheets of workbook with one step
 

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.