Excel 2007 : Lose formatting when I copy a table from worksheet and past in another worksheet

When I copy a table that i have built in a worksheet and then paste it into another worksheet, I am losing all the formatting for that table. It pastes only the data. Fonts, highlighting, borders etc are all dropped. There must be an option that can be selected to control this. I have an old laptop with Excel 2007 that retains the formatting. But I have been given a new laptop with the same software and the formatting is not retained, but I can't see what option is controling this. Any help is appreciated. thanks