Rows & Columns on a page

S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Page Breaks 10
Excel Unable to insert cut rows into Excel online anymore? 0
How to search with excel 1
New spreadsheet only prints the first page 2
Copy & Paste lost row heights 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
change column to row display 3
Cannot print first cells on page 3 of Excel 2000 Spreadsheet. 7

Top