Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Some worksheets not viewable within a workbook on a particular PC | Excel Discussion (Misc queries) | |||
create multiple worksheets in workbook from one csv file | Excel Discussion (Misc queries) | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) |