From: Martin ���� on
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
����
From: Dave Peterson on
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
From: Martin ���� on
On Wed, 05 May 2010 11:41:49 -0500, Dave Peterson
<petersod(a)verizonXSPAM.net> 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
>> ����