Formatting

Hi Aisha

Thank you for your question. When you paste data into your workbook Excel puts a Smart Tag in the lower right corner of the pasted data. Click on the Smart Tag and you will find one of the choices allows you to paste the data in line with destination sheet's formatting.

I hope this helps.
Kind regards,
Andrew