I am trying to copy an entire worksheet (I click in the box above the rows and before the columns, once the entire sheet is highlighted, I copy) that has page orientations preset and page breaks after certain data. I open a new worksheet and paste the data, but can't get the page orientation and page breaks to carry forward to the new sheet. I've tried paste special but it doesn't seem to have the right option.

Is there a way to do this or do I have to reset both everytime I copy the worksheet to a new workbook?

I am using Excel 2010, but the original workbook was created using Excel 2007. Thanks!