Copy Group rows formatting

[Guest]

Any idea if there is a way to copy my group rows format from one sheet to another? For example I want to group rows 6-24 and 26-38 etc. But I want to copy this from 1 worksheet to 10 others.

Thanks in advance
Dan

 

[Ken Wright]

Select the entire sheet using the small square above the 1 and to the left of
the A, then copy. Hit the same spot on the next sheet to select it all, or just
A1 and paste special / formats

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Any idea if there is a way to copy my group rows format from one sheet to

another? For example I want to group rows 6-24 and 26-38 etc. But I want to
copy this from 1 worksheet to 10 others.