How do I column wrap an Excel printout

[Rolls100]

I have 10 pages of 2 skinny columns to print out.

In MSWord I would just CTRL-A, select the column button, select 2 columns and Wala - now I have a 5 page printout. The column on the left of a page continues on the top right of the same page - goes to the bottom and THEN starts a new page.

I want:
Page 1: Col A&B rows 1 -50 on the left of the page
Col A&B rows 51 -100 on the right of the page

Page 2: Col A&B rows 101 -150 on the left of the page
Col A&B rows 151 -200 on the right of the page

etc., etc.

I'm sorry for the "Column" definition problem between MSWord and Excel - I hope I have been able to explain this problem accurately

I posted this on another board - 9 views and no replies - so I'm trying here.

 

[erik.van.geit]

Rolls100,

WELCOME to the Board!!

Would making a temporary sheet setup the way you want be a solution?

kind regards,
Erik

 

[Mark W.]

See ASAP Utilities' "The paper saver" formatting option. www.asap-utilities.com

 

[Rolls100]

Thanks for the response

Erik - I'm not sure what you mean by creating a temp file - unless you mean just cut and past-up a list. And that may work in a pinch. In fact I could cut & paste-links and still be able to make row changes , I could not add or delete rows.

Mark - I'm going to try the ASAP suggestion too. By the way - I'm over in Bryan/College Station and my wife's a T-Sip.

 

[erik.van.geit]

Rolls100,

Yes just making a sheet, pasting the values in printabel order and then delete the sheet.

If ASAP works for you it would be better, if not be welcome again!

kind regards,
Erik

 

[Rolls100]

The ASAP PlugIn did it!

It worked using the ASAP / Format / The Paper Saver (split columns) feature. Too Cool!!!

I really appreciate the input from both you guys - I have wanted to do this for YEARS and could never figure out how. It looks like the Paper Saver featur does in 3 seconds (on a 5237 row file) what it would have taken me 30 minutes to cut & paste together.

What makes this really neat FREE utility so GREAT is that as I make changes - it is still only 3 seconds to re-format and re-print. I can Add/Delete rows, switch to landscape, re-sort the entire list, etc.

After 16views on another major Excel forum I got ZERO replies in about 30 hours.

Mark & Erik your help was wonderful!

Thanks Again,
Royce

 

[Mark W.]

Okay, how much is ASAP Utilities paying you! :wink: