Hello...

I have got some spreadsheets with three columns as follows

REF PRICE SURCHARGE

The spreadsheets have got over 2000 rows. If I try to print them they will
come out on to 47 pages. To get it to print on fewer pages, on one of the
spreadsheets I have cut and pasted it so that it now looks like this,

REF PRICE SCHARGE REF PRICE SCHARGE REF PRICE SCHARGE

I did this by making the extra column headers and cutting & pasting at the
page breaks. This took me all morning and I'm dreading doing it to the other
spreadsheets. Does anyone know a quicker way I could tackle this problem.

Many Thanks


Luke

Cheers David...

Luke

David McRitchie <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Hi Shaftec,
> Not supported in Excel, but a macro would help you.
> See http://www.mvps.org/dmcritchie/excel/snakecol.htm
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Shaftec Automotive" <(E-Mail Removed)> wrote in
message news:bh8b2u$9ha$(E-Mail Removed)...
> > Hello...
> >
> > I have got some spreadsheets with three columns as follows
> >
> > REF PRICE SURCHARGE
> >
> > The spreadsheets have got over 2000 rows. If I try to print them they
will
> > come out on to 47 pages. To get it to print on fewer pages, on one of
the
> > spreadsheets I have cut and pasted it so that it now looks like this,
> >
> > REF PRICE SCHARGE REF PRICE SCHARGE REF PRICE SCHARGE
> >
> > I did this by making the extra column headers and cutting & pasting at
the
> > page breaks. This took me all morning and I'm dreading doing it to the
other
> > spreadsheets. Does anyone know a quicker way I could tackle this
problem.
> >
> > Many Thanks
> >
> >
> > Luke
> >
> >
>
>