Printing non-adjacent columns

  • Thread starter Thread starter Ebeneezer
  • Start date Start date
E

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 ?
 
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
 
Back
Top