Right click where you want to paste and click "paste special". You will then
need to toggle on the formatting button.
This should do the trick.

Christopher

"Confused" wrote:

I am trying to add the same format to another worksheet but have no idea how
to do it. Everytime I cut and paste to another sheet, my formatting is all
gone. Any suggestions?