Move all page contents to another page - how?

[Martin ©¿©¬]

Hi
I have a workbook with 14 pages
I add page 15 & 16 which are blank

How do I move all of page 14 (contents, page layout, formating,
headers/footers EVERYTHING as is) to page 16 ??
Thank you

 

[Dave Peterson]

Don't add new blank pages.

Instead, copy the sheet you want to a new location.

You can select the sheet
Then Edit|move or copy sheet (in xl2003 menus)
and copy (check that option!) to a new location within the same workbook.

You can also do the same by ctrl-clicking on the sheet tab and dragging to the
right or left.

 

[Martin ©¿©¬]

Don't add new blank pages.

Instead, copy the sheet you want to a new location.

You can select the sheet
Then Edit|move or copy sheet (in xl2003 menus)
and copy (check that option!) to a new location within the same workbook.

You can also do the same by ctrl-clicking on the sheet tab and dragging to the
right or left.

Thank you Dave