ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I want to change the page order so that page 3 and 4 become 1and2 (https://www.excelbanter.com/excel-discussion-misc-queries/236101-i-want-change-page-order-so-page-3-4-become-1and2.html)

MK

I want to change the page order so that page 3 and 4 become 1and2
 
I have 4 pages in my file and they all inculed special fornatiing. If I move
them by using cut and past their formatting is not kept and taht is lot of
work. If I use special paste it keeps the format but then it paste it as an
image for some reason does not allow to work on the fields.

All I want to change the order of the pages. so that 3 and 4 becomes 1 and 2
and 1and 2 becomes 3 and 4.

Gord Dibben

I want to change the page order so that page 3 and 4 become 1and2
 
In Excel a file is a workbook.

A workbook can contain one or more worksheets.

A worksheet can contain one or more pages if you are printing.

What do you want to change the order of?

Worksheets within a workbook?

Pages within a worksheet?

What type of formatting is used that does "keep"?


Gord Dibben MS Excel MVP

On Tue, 7 Jul 2009 11:26:07 -0700, mk wrote:

I have 4 pages in my file and they all inculed special fornatiing. If I move
them by using cut and past their formatting is not kept and taht is lot of
work. If I use special paste it keeps the format but then it paste it as an
image for some reason does not allow to work on the fields.

All I want to change the order of the pages. so that 3 and 4 becomes 1 and 2
and 1and 2 becomes 3 and 4.




All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com