print area options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I chose page setup from file> sheet> print area
then..
I selected 2 seperated parts in sheet 1 to add it to the box of print area
this is what was typed in the box:
A1:G6,A9:G14

in print preview, each selected part was displayed in a seperate page .. so
I had 2 pages to be printed

is there any way to make them appear/or printed in one page?
 
Copy each selection to a new sheet and print the new sheet or
try the free Excel add-in "Print Selections Only".
Download from http://www.realezsites.com/bus/primitivesoftware
Includes a Word.doc install/use file.
--
Jim Cone
San Francisco, USA


"r" <[email protected]>
wrote in message...
I chose page setup from file> sheet> print area
then..
I selected 2 seperated parts in sheet 1 to add it to the box of print area
this is what was typed in the box:
A1:G6,A9:G14
in print preview, each selected part was displayed in a seperate page .. so
I had 2 pages to be printed
is there any way to make them appear/or printed in one page?
 
Hi,
Based on the ranges you have mentioned it would be easiest to select
rows 8 & 9 (by holding down shift as you click on the #'s at the left
of the sheet), right clicking, selecting "Hide", then selecting the
area you want printed and printing it.

However, if you want to see some other approaches, have a read of Ron
de Bruin's page:
http://www.rondebruin.nl/print.htm

hth,
Rob Brockett
Always learning & the best way to learn is to experience...
 
where can I find Excel add-in "Print Selections Only".

can you explain more please

Thank you
 
Back
Top