Excel: Printing 3 Columns as 6 Colums on one Page

I have a list covering 3 columns and 334 rows. Can I get Excel 2003 to print the columns on one page so that there 6 columns on the page?

 

Hava a look at your print drivers. Some printers (for example the Xerox DC440) will allow you to overwrite the Application settings, so the application thinks it is printing to two sheets of A4 when in fact it is printing to two halves of a single sheet of A3. With that facility you could set Excel to print the data onto two A5 sheets (portrait), but use the print drivers to print the output to two halves of an A4 sheet (landscape).

The boring way to do it is to use a seperate page with links to the orignal page and the data arranged the way you want it. Hightlight the first half of the data and select copy. Go to the new sheet and paste. Highlight the second half of the data and select copy. Go to the new sheet and paste the data next to the first lot.

You could record a macro to automate the process.

If you really want to go to town, use VBA to count the number of data entries, copy the data in two halves based on the number of entires and output them to a new page. The code could also include the printing and delete the new sheet afterwards.