sheet layout & printing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2002 (10.4302.4219) SP-2, Win 2000.

2 questions that are about the same thing:

How can I print 2 worksheets in the same workbook on a single piece of paper?

Can I divide a single worksheet into sections such that rows 1-25 have columns with variable column widths and the same columns on rows 26-50 in the same sheet have different column widths? This would be a wonderful thing and make many sheets so much easier to read and use.

Thanks for all good ideas.
 
Try this this Tom
http://www.rondebruin.nl/print.htm#non-contiguous

No for your second question

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




TomExcel said:
Excel 2002 (10.4302.4219) SP-2, Win 2000.

2 questions that are about the same thing:

How can I print 2 worksheets in the same workbook on a single piece of paper?

Can I divide a single worksheet into sections such that rows 1-25 have columns with variable column widths and the same
Click to expand...
columns on rows 26-50 in the same sheet have different column widths? This would be a wonderful thing and make many sheets so
much easier to read and use.
 
One way is to copy the both print ranges to a new sheet and print from there.

Another that might be easier:
insert a new sheet
select the first range
edit|copy
got to A1 of the new sheet
Shift-Edit|Paste Picture link

do the same for the other range and print from that "helper" worksheet.

Try changing some values in your real data. Now go back to the pictures.
Pretty neat, huh. Since you pasted a picture line, the picture got updated.
 
Back
Top