MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Worksheet Grouping

Posted by Bill Calliss on May 07, 2001 12:09 PM

When I used Lotus 123, I was able to group worksheets
such that when I added a column or row, or any other
formatting process, it was done on all grouped sheets.

Is there a similar function in Excel and if so, how
can I activate it?



Posted by IML on May 07, 2001 12:29 PM

You can select several worksheets by clicking on the tabs while holding down the control key. For several sheets in a row, you can use the shift key.