| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ©¿©¬ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
| Move data line from end of page 1 to page 2 | Charts and Charting in Excel | |||
| Contents Page | Excel Discussion (Misc queries) | |||
| Cursor doesn't move when page up or page down in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I move the data in one cell on a page to another page/cell | Excel Discussion (Misc queries) | |||
Linear Mode
