Move all page contents to another page - how?
 

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
--
Martin
©¿©¬

Move all page contents to another page - how?
 

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, ©¿©¬, @nohere.net wrote:

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
--
Martin
©¿©¬

--

Dave Peterson

Move all page contents to another page - how?
 

On Wed, 05 May 2010 11:41:49 -0500, Dave Peterson
wrote:

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
--
Martin
©¿©¬

Martin, ©¿©¬, @nohere.net wrote:

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
--
Martin
©¿©¬