Rows & Columns on a page

[Shaftec Automotive]

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

 

[Shaftec Automotive]

Cheers David...

Luke

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" <[email protected]> wrote in

message news:[email protected]...