Problems Setting Columns to Print

K

Kristen

I have a speadsheet (Excel 2000) that consists of a range
of cells (A1:AV44) - I want to print columns A thru Y on
page one and columns Z thru AV on page 2. I cannot figure
this out. The margins are all set at 1" all the way
around. I changed the scaling, margins, fit to 2 pages by
1 page. I don't know what else to do. Does anyone have
any suggestions?

Thank you
 
F

Frank Kabel

Hi
one workaround:
- start recording a macro
- select columns A:Y and goto 'File - Printarea
- set the printarea and print this range (one one single
sheet)
- now select the other range, set the printarea and print
this part of your sheet

After this stop recording a macro and use this macro for
the future :)
 
Top