Move all page contents to another page - how?
in [General]
|
Prev: Problem with Paste and Automatically repeating values - no fill ha
Next: Sumproduct Dynamic Range - XL2003
From: Martin ���� on 5 May 2010 11:01 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 5 May 2010 12:41 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 6 May 2010 07:55
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 >> ���� |