Paste Page Breaks

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!

Instead of copying the cells within the worksheet, you need to copy the worksheet itself.

Follow this link for detailed instructions.

http://www.howtogeek.com/howto/8810/...cel-2007-2010/

Perfect! Worked like a charm.