Group Mode in Lotus 1-2-3


Posted by Laura on October 12, 2000 11:24 AM


In Lotus 1-2-3 Rel. 5, you can select Style, Worksheet Defaults and then select Group Mode in order automatically have your formatting applied to additional worksheets. Can you do this in Excel?



Posted by Ivan Moala on October 13, 2000 2:15 AM

The "Across worksheets" commandbutton will do this for you.
GOTO;
Customize / Commands / Edit
then look for "Across worksheets"
and add this button to your toolbars vai drag & drop.

Select the range to copy format then
selecet the sheets while holsing down the shift key......the Across sheets button will then
be enabled .....just click this and select the
option you want.

Ivan