On the Home ribbon, there is a button to the far left called "Format
Painter". It works just like copy/paste for formatting only. Select what
you want to copy, click the button, then select what you want to apply it to.

"Jordan" wrote:

Hello,

Whenever I copy data from one worksheet to a 2nd worksheet, the formatting
changes (on the 2nd worksheet) even though I use the "paste special" all
feature. Is there a solution to this?

Regards,