Hide the columns that are between the areas you want to print.

If your printrange consists of multiple discontiguous areas, you'll get multiple
sheets of paper.

Alternatively, you could copy each discontiguous range to another sheet (as
pictures???) and print from there.

Shazza wrote:

My print area is 3 different collums and they are not all together i used
page set up to set the print area and i have ticked on fit to 1 page wide and
1 page tall but it still keeps putting each of the different collums onto a
new page i want all of the collums onto 1 page.
--
Thank you for reading my post. Hopefully you can answer my querie

"Marcelo" wrote:

File | page setup | check fit to 1 page wide 1 page tall

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Shazza" escreveu:

Hi working with excel 2000 i have set my print area of the data that i want
to print but it is printing onto 2 - 3 different pages how can i get it to
print it all onto one page. i have tried scaling it to fit one page but that
doesn't work
--
Thank you for reading my post. Hopefully you can answer my querie

--

Dave Peterson