Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 4th 05, 12:26 PM
Wilde
 
Posts: n/a
Default 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?

  #2   Report Post  
Old November 4th 05, 12:56 PM
Barb Reinhardt
 
Posts: n/a
Default 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?



  #3   Report Post  
Old November 4th 05, 01:04 PM
Wilde
 
Posts: n/a
Default 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. Isn’t 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?




  #4   Report Post  
Old November 4th 05, 01:52 PM
Ron Rosenfeld
 
Posts: n/a
Default 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
  #5   Report Post  
Old November 8th 05, 09:56 AM
Wilde
 
Posts: n/a
Default 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



  #6   Report Post  
Old November 8th 05, 12:07 PM
Ron Rosenfeld
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print conditional worksheets jhicsupt Excel Discussion (Misc queries) 2 October 8th 05 01:01 PM
Print order of worksheets Stray Doug Excel Discussion (Misc queries) 3 September 21st 05 12:37 AM
Print mult worksheets to Adobe John Day Excel Discussion (Misc queries) 2 May 25th 05 03:54 PM
What is the simplest way to print multiple worksheets? substring Charts and Charting in Excel 1 April 21st 05 11:49 PM
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 3 December 31st 04 10:31 AM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017