On 8/26/07 10:14 PM, in article
F278BC4D-C2E5-4EA0-99DC-A52A35CDD911@microsoft.com, "Nikki"
> Hi,
>
> Is there a way to take an entire formatted section of excel (grouped and
> coloured etc) and paste it below with the click of a button?
>
> Regards
You could use the camera tool to 'take a picture" of the area and paste it
where ever you want. The picture is "live" in that it will change when the
original cells change, but you will not otherwise be able to change the
image.

Signature
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
Not with "a single button" - but select/copy/paste can't be all that much
trouble:-)

Signature
Regards |:>)
Bob Jones
[MVP] Office:Mac
> Hi,
>
> Is there a way to take an entire formatted section of excel (grouped and
> coloured etc) and paste it below with the click of a button?
>
> Regards