How do I get my worksheets to print in the right order?
 

I am trying to print some worksheets. In preview they display correctly
however when printing it is all over the place? How would I fix this?

How do I get my worksheets to print in the right order?
 

What exactly is all over the place?

"Wilde" wrote in message
...
I am trying to print some worksheets. In preview they display correctly
however when printing it is all over the place? How would I fix this?

How do I get my worksheets to print in the right order?
 

I have a 15 sheet workbook that prints over 17 pages. However when printing,
the worksheets are not printing in the order that it is displayed in the
print preview. Worksheets 1,2 print and then worksheet 4 prints and then
only worksheet 3 prints followed by sheet 5 and the makes a lovely big jump
to worksheet 11, 10,9,8,7,6,12,14,13,16,15. Bearing in mind these worksheets
have been renamed, but the numbering is the order of the sheets displayed
from left to right. Isnt this just SO weird. How do I correct this? I have
looked everywhere for help on the problem.


"Barb Reinhardt" wrote:

What exactly is all over the place?

"Wilde" wrote in message
...
I am trying to print some worksheets. In preview they display correctly
however when printing it is all over the place? How would I fix this?

How do I get my worksheets to print in the right order?
 

On Fri, 4 Nov 2005 04:26:11 -0800, "Wilde"
wrote:

I am trying to print some worksheets. In preview they display correctly
however when printing it is all over the place? How would I fix this?

Have you tried the Report Manager?

It should be able to let you specify the order of printing of worksheets. In
Excel 2002 it is a downloadable add-in. In some of the other versions it was
included with the program. Type Report Manager into HELP for more information.


--ron

How do I get my worksheets to print in the right order?
 

Thanks for the help Ron. I managed to install Report Manager on my 2003
version and it WORKS!
"Ron Rosenfeld" wrote:

On Fri, 4 Nov 2005 04:26:11 -0800, "Wilde"
wrote:

I am trying to print some worksheets. In preview they display correctly
however when printing it is all over the place? How would I fix this?

Have you tried the Report Manager?

It should be able to let you specify the order of printing of worksheets. In
Excel 2002 it is a downloadable add-in. In some of the other versions it was
included with the program. Type Report Manager into HELP for more information.


--ron

How do I get my worksheets to print in the right order?
 

Glad it worked out for you.

Best wishes,
--ron




On Tue, 8 Nov 2005 01:56:01 -0800, "Wilde"
wrote:


Thanks for the help Ron. I managed to install Report Manager on my 2003
version and it WORKS!
"Ron Rosenfeld" wrote:

On Fri, 4 Nov 2005 04:26:11 -0800, "Wilde"
wrote:

I am trying to print some worksheets. In preview they display correctly
however when printing it is all over the place? How would I fix this?

Have you tried the Report Manager?

It should be able to let you specify the order of printing of worksheets. In
Excel 2002 it is a downloadable add-in. In some of the other versions it was
included with the program. Type Report Manager into HELP for more information.


--ron


--ron