Printing non-adjacent columns

[Ebeneezer]

In Excel 2000, when I select 2 non adjacent columns and
go - file|print, the columns print on two sheets of paper
even though file|page setup|page - fit to 1 page wide/1
page tall is opted and the columns are not far apart from
one another. Is there some way of making them print on 1
sheet of paper ?

 

[Gord Dibben]

Ebeneezer

One way around this is to set your print range to include the in-between
columns in your print range, then hide the columns you don't want printed.

i.e. you want columns B and E printed. Select B through E as print range.
Hide C and D.

Gord Dibben Excel MVP - XL97 SR2 & XL2002