Multiple Print Ranges on Same Sheet

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

A few years ago, I used to be able to designate multiple
print rangs on a single sheet and print same.

Can anyone help refresh me as to how that is done?

Thanks
 
If you select your discontiguous range(s), you can then

file|print area|set print area

(be aware that this will print each area on a separate sheet of paper.)
 
Dennis,
You can select the multiple areas by holding your control key, and then File> Print_Area>Set_Print_Area.

Or you could enter the areas directly under File>Page_Setup>Sheet>Print_Area. You would use the format A1:E5,A8:F12.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Dennis wrote: -----

A few years ago, I used to be able to designate multiple
print rangs on a single sheet and print same.

Can anyone help refresh me as to how that is done?

Thanks
 
If you select your discontiguous range(s), you can then

file|print area|set print area

(be aware that this will print each area on a separate sheet of paper.)
Click to expand...
...

One of Excel's long lasting defects/omissions compared to its surviving
competitors.

To print multiple nonadjacent areas on a single piece of paper, copy each of
them and paste them as piture links on a new, blank worksheet, then select the
smallest range on that new worksheet that contains the linked pictures. Crude
but effective.
 
Back
Top