copying/pasting

[praptisahni]

when i try to copy paste from one workbook to another, my formatting i
not copied, only the data gets copied, how do i copy paste along wit
the formattin

 

[Don Guillett]

try edit>paste special