Database - printing 2 columns to a page

[rireland]

I have a database of 1000 names + addresses ( each record has 4 columns) . I want to print 2 x 4 columns of details to a page - in alphabetical order.
I can get 60 lines to a printed page. So on page 1 there would be records 1-60 on the left of the page and records 61 to 120 on the right.

Next page would have 121 to 180 on the left and then 181 to 240

The only way I can achieve this is by a laborious cut & paste.

Is there an easier way?

Richard

 

[Makrini]

Depending on your printer - you can actually do this in your print settings.

(In Excel 2007 - Page setup - sheet tab - options)

Mine brings up an option for "2Up" - my work one (Excel 2003 - but different printer) brings up "2 to a page"

- My next point is a little semantics - so take what you will from it (I mean no offense)...

You don't have a "database" - you have a "list". A database is something completely different - although its a common mistake - and Excel is sometimes used "like" a database.

 

[rireland]

Thanks - I knew there was a simple solution for my "list" somewhere.
R