newspaper style printing

  • Thread starter Thread starter excel newspaper style printing
  • Start date Start date
E

excel newspaper style printing

Is there a simple click, click to command excel to fill
the whole page when printing. Example there are only 3
columns, but many rows. When it fills up a 8.5 piece of
paper on the left hand column, start printing in the
middle at the top of the page and fill up the other side
(newspaper column type formatting).
Dept 1
EDWARD 2022325555
GREGORY 2022325556
TOM 2022325557
SHIRLEY 2022325558
THOMAS 2022325559
Dept 2 2022325345
THOMAS 2022325559
JAMES 2022325558
ANNA 2022325557
BILL 2022325556
JUDY 2022325554
KAREN 2022325553
Dept 3
JEFFREY 5559022398
DAN 555902239
REBA 5559022396
Dept 5 5559122398
BUDD 5559022398
ROBERT 5519022398
JOHN 5529022398

Thanks.
 
David McRitchie has a web page on this subject:

http://www.mvps.org/dmcritchie/excel/snakecol.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

in message Is there a simple click, click to command excel to fill
the whole page when printing. Example there are only 3
columns, but many rows. When it fills up a 8.5 piece of
paper on the left hand column, start printing in the
middle at the top of the page and fill up the other side
(newspaper column type formatting).
Dept 1
EDWARD 2022325555
GREGORY 2022325556
TOM 2022325557
SHIRLEY 2022325558
THOMAS 2022325559
Dept 2 2022325345
THOMAS 2022325559
JAMES 2022325558
ANNA 2022325557
BILL 2022325556
JUDY 2022325554
KAREN 2022325553
Dept 3
JEFFREY 5559022398
DAN 555902239
REBA 5559022396
Dept 5 5559122398
BUDD 5559022398
ROBERT 5519022398
JOHN 5529022398

Thanks.
 
Back
Top