moving columns for printing

NCay

Board Regular
Joined
Jul 15, 2002
Messages
214
I have to print off a column of numbers - well over 1000 . Rather than print 20 pages- how can I set up to have four or five columns per page? I've have a look around the page break and printing prefs but have so far drawn a blank. I don't want to do this as four pages on one via the printer setting as this substantially reduces font size.
...Suggestions please...
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
download the asap addin:

http://www.asaputilities.com

It has an option that does what you want ('the paper saver' in the format options).

Paddy

EDIT - typos!
This message was edited by PaddyD on 2002-09-24 19:59
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Have you tried viewing the area to print in "View pagebrake"....you should be able to drag the col or row seperator to the range that fits your alignment requirements.

pll
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
PaddyD
the referenced site notes the reply "The page cannot be found" could you please check.

pll
This message was edited by plettieri on 2002-09-24 19:00
This message was edited by plettieri on 2002-09-24 19:01
 

NCay

Board Regular
Joined
Jul 15, 2002
Messages
214
FYI.
link will work if www. used instead of www/ as written in the post
 

NCay

Board Regular
Joined
Jul 15, 2002
Messages
214
I've had a quick look around asaputilities and the content looks pretty darned good - my main concern is if there are any known issues or probs with installing and using this add-in.
I have had numerous problems with programs crashing/locking out after installing them and as such am a lot more cautious now.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
None that I know of - the asap addin is about as reputable as they come!

May be others have had problems...

Paddy
 

NCay

Board Regular
Joined
Jul 15, 2002
Messages
214
ok,fair point- in that case I'll give it a go. Cheers for the info.
 

Forum statistics

Threads
1,181,461
Messages
5,930,064
Members
436,718
Latest member
messa57fr

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