How do I column wrap an Excel printout

Rolls100

New Member
Joined
Feb 15, 2005
Messages
3
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.
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Rolls100,

WELCOME to the Board!!

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

kind regards,
Erik
 

Rolls100

New Member
Joined
Feb 15, 2005
Messages
3
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

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832

ADVERTISEMENT

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

New Member
Joined
Feb 15, 2005
Messages
3
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
 

Watch MrExcel Video

Forum statistics

Threads
1,126,972
Messages
5,621,905
Members
415,865
Latest member
pxmike

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top