software

I chose page setup from filegt; sheetgt; 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 quot;Print Selections Onlyquot;.
Download from www.realezsites.com/bus/primitivesoftware
Includes a Word.doc install/use file.
--
Jim Cone
San Francisco, USAquot;rquot; gt;
wrote in message...
I chose page setup from filegt; sheetgt; 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 amp; 9 (by holding down shift as you click on the #'s at the left
of the sheet), right clicking, selecting quot;Hidequot;, 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:
www.rondebruin.nl/print.htm

hth,
Rob Brockett
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=531234where can I find Excel add-in quot;Print Selections Onlyquot;.

can you explain more please

Thank you

quot;Jim Conequot; wrote:

gt; Copy each selection to a new sheet and print the new sheet or
gt; try the free Excel add-in quot;Print Selections Onlyquot;.
gt; Download from www.realezsites.com/bus/primitivesoftware
gt; Includes a Word.doc install/use file.
gt; --
gt; Jim Cone
gt; San Francisco, USA
gt;
gt;
gt; quot;rquot; gt;
gt; wrote in message...
gt; I chose page setup from filegt; sheetgt; print area
gt; then..
gt; I selected 2 seperated parts in sheet 1 to add it to the box of print area
gt; this is what was typed in the box:
gt; A1:G6,A9:G14
gt; in print preview, each selected part was displayed in a seperate page .. so
gt; I had 2 pages to be printed
gt; is there any way to make them appear/or printed in one page?
gt;

You can't go to the link that Jim provided and find it?www.realezsites.com/zips/Prin...yRelease10.zip

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;rquot; gt; wrote in message
...
gt; where can I find Excel add-in quot;Print Selections Onlyquot;.
gt;
gt; can you explain more please
gt;
gt; Thank you
gt;
gt; quot;Jim Conequot; wrote:
gt;
gt;gt; Copy each selection to a new sheet and print the new sheet or
gt;gt; try the free Excel add-in quot;Print Selections Onlyquot;.
gt;gt; Download from www.realezsites.com/bus/primitivesoftware
gt;gt; Includes a Word.doc install/use file.
gt;gt; --
gt;gt; Jim Cone
gt;gt; San Francisco, USA
gt;gt;
gt;gt;
gt;gt; quot;rquot; gt;
gt;gt; wrote in message...
gt;gt; I chose page setup from filegt; sheetgt; print area
gt;gt; then..
gt;gt; I selected 2 seperated parts in sheet 1 to add it to the box of print
gt;gt; area
gt;gt; this is what was typed in the box:
gt;gt; A1:G6,A9:G14
gt;gt; in print preview, each selected part was displayed in a seperate page ..
gt;gt; so
gt;gt; I had 2 pages to be printed
gt;gt; is there any way to make them appear/or printed in one page?
gt;gt;If you click the link in my message, it takes you to the website.
The program is on the quot;Productsquot; page about 3/4 of the way down the page.
There is a download link next to the name.

Here is the direct link to the products page...
www.realezsites.com/bus/primi...e/products.php

Jim Conequot;rquot; gt;
wrote in message
where can I find Excel add-in quot;Print Selections Onlyquot;.
can you explain more please
Thank you
quot;Jim Conequot; wrote:
gt; Copy each selection to a new sheet and print the new sheet or
gt; try the free Excel add-in quot;Print Selections Onlyquot;.
gt; Download from www.realezsites.com/bus/primitivesoftware
gt; Includes a Word.doc install/use file.
gt; --
gt; Jim Cone
gt; San Francisco, USA
gt;
gt;
gt; quot;rquot; gt;
gt; wrote in message...
gt; I chose page setup from filegt; sheetgt; print area
gt; then..
gt; I selected 2 seperated parts in sheet 1 to add it to the box of print area
gt; this is what was typed in the box:
gt; A1:G6,A9:G14
gt; in print preview, each selected part was displayed in a seperate page .. so
gt; I had 2 pages to be printed
gt; is there any way to make them appear/or printed in one page?
gt;

sorry
at the beginning, i thought it is an option already found in Excel.

Thank you

quot;Jim Conequot; wrote:

gt; If you click the link in my message, it takes you to the website.
gt; The program is on the quot;Productsquot; page about 3/4 of the way down the page.
gt; There is a download link next to the name.
gt;
gt; Here is the direct link to the products page...
gt; www.realezsites.com/bus/primi...e/products.php
gt;
gt; Jim Cone
gt;
gt;
gt; quot;rquot; gt;
gt; wrote in message
gt; where can I find Excel add-in quot;Print Selections Onlyquot;.
gt; can you explain more please
gt; Thank you
gt;
gt;
gt;
gt; quot;Jim Conequot; wrote:
gt; gt; Copy each selection to a new sheet and print the new sheet or
gt; gt; try the free Excel add-in quot;Print Selections Onlyquot;.
gt; gt; Download from www.realezsites.com/bus/primitivesoftware
gt; gt; Includes a Word.doc install/use file.
gt; gt; --
gt; gt; Jim Cone
gt; gt; San Francisco, USA
gt; gt;
gt; gt;
gt; gt; quot;rquot; gt;
gt; gt; wrote in message...
gt; gt; I chose page setup from filegt; sheetgt; print area
gt; gt; then..
gt; gt; I selected 2 seperated parts in sheet 1 to add it to the box of print area
gt; gt; this is what was typed in the box:
gt; gt; A1:G6,A9:G14
gt; gt; in print preview, each selected part was displayed in a seperate page .. so
gt; gt; I had 2 pages to be printed
gt; gt; is there any way to make them appear/or printed in one page?
gt; gt;
gt;