How to make long Excel worksheet print across the page
Posted on 2000-05-09
I have an Excel worksheet that has 3 columns and about 900 rows. The total width of the 3 columns is only about 2 inches. When I print this it takes about 20 pages but there is a lot of wasted space on the right hand side of the pages. I would like to make the 3 columns repeat accross the page (like you can do with Word "columns" formatting) before jumping to the next page. If I can get 3 sets of columns to print on a page, I will only have about 7 pages to deal with instead of 20, and I would save paper too. COPYING AND PASTING IS NOT AN ACCEPTABLE SOLUTION. I want this to happen automatically, without the need for manual manipulation.