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

[Guest]

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?

 

[Barb Reinhardt]

What exactly is all over the place?

 

[Guest]

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. Isn’t this just SO weird. How do I correct this? I have
looked everywhere for help on the problem.

 

[Ron Rosenfeld]

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

 

[Guest]

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

 

[Ron Rosenfeld]

Glad it worked out for you.

Best wishes,
--ron

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

--ron