Print multiple selections on 1 sheet of paper

[tobor]

Hello,
I have a very large spreadsheet of data and calculations. I would like to know if I can select three sections of results and print them all on the same page? For example, If I select B3:H5 and AG89:AJ97 and tell excel to print the selected it will print on two separate sheets of paper. I want to make it print on one sheet of paper.

Thank you in advance

 

[PA HS Teacher]

Hmm... I don't know how this could be done by setting the Print Area, but would you be willing to hide the unused rows and columns?

 

[ajetrumpet]

you might try to use the set print area option in the file menu after you highlight your selection. Try this:

File > Print Area > Set Print Area