how to use "All using source theme" (paste special

[amitkr3855]

Hi,

how to use all using source theme in paste special excel 2007
i have tried so many in google but i really can't help it, pl. shave any link regarding it or tell me how to use this,

Thanx
Amit

[meritcomp]

If you have applied any theme to source sheet (Page layout - Themes) and want to apply same theme at target sheet then select source data, copy it and paste it using Paste special -> All using source theme. It works similar to Paste Special ->Formats.
Vishvas