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