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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

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

ADVERTISEMENT

FYI.
link will work if www. used instead of www/ as written in the post
 

NCay

Board Regular
Joined
Jul 15, 2002
Messages
214

ADVERTISEMENT

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,143,917
Messages
5,721,529
Members
422,369
Latest member
redinator

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