I have a list that has 1800 rows and only 4 colums. Excel should allow me to
automatically break the list and have it put side by side, across the page.
This would take a list of 35 pages and put it on approximately 9 pages. I
could cut & paste, but there must be an easier method.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

On Thu, 9 Mar 2006 16:05:27 -0800, Richierich
wrote:

I have a list that has 1800 rows and only 4 colums. Excel should allow me to
automatically break the list and have it put side by side, across the page.
This would take a list of 35 pages and put it on approximately 9 pages. I
could cut & paste, but there must be an easier method.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions


Should be fairly easy with a looping macro.
Just decide how many rows you want per 'page' and then starting in the
first cell, have the macro drop down the no. of rows, select all the
rows below this, cut them and paste back on the first row but offset 4
columns, then repeat until 1800/n_rows times.

HTH
Richard Buttrey
__