Excel - Snaking columns

My OS is windows 7 and I use Excel 2007.  I have an Excel file which has 2 columns and about 10,000 rows.  I have set the page layout to potrait and .5" margins.  Invariably the data goes beyond one page.  How can I get the last row before the page break to wrap  the 2 columns to the next (which is going to be the 3rd and 4th)  column .  Thank u.
jegajothyretiredAsked:
Who is Participating?
 
wchhCommented:
Sorry, Try:
Page Setup->Sheet->Page order->Select Over, then down radiobutton
0
 
wchhCommented:
Try:
Page Setup->Sheet->Page order->Select Over, and down radiobutton
0
 
jegajothyretiredAuthor Commented:
well answered
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.