How to copy block of cells and keep grouping?

[dstock]

I have about a 150 by 30 block of cells. About every 5 cells are grouped together, making it significantly smaller. when you click the "-" to have them contract.

I will take me days to go through and make all the groups again if I want to make the same block on the same worksheet.

Is there a way to copy a block of cells and include the grouping?

Thanks

[Ron Coderre]

If you select entire rows or entire columns when you Copy, then Pasting will include the Grouping.

Alternatively, if you Copy the grouped rows or columns, you can Paste Special>Formats to apply the Grouping to a previously ungrouped range.

Does that help?

Regards,
Ron

[dstock]

Yes that worked, thank you kind sir!