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.

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.