how to print
 

i have a worksheet round about 10000 records in it. and i want to print a few
records . for example i want to print record number 2 , 34 , 100 , 501 and
590 on a single page. even i tried to select record number 2,34,100,501 and
590 but i was give the print on different page for each record. but i want to
print them on a single page. i hope u understand it very well , what i am
saying.Thanks

One way is to *hide* the rows between the rows that you wish to print.

Then, select the cells you wish to print and go to:

<File <PrintArea <Set PrintArea

Check "Print Preview" to make sure that you'll get exactly what you're
looking for.

You may have to also then go to <File <PageSetUp <Page tab,
And check "Fit to 1 Page wide by 1 page tall", if XL truncates the page to
less then what you're looking to print.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"reneabesmer" wrote in message
...
i have a worksheet round about 10000 records in it. and i want to print a
few
records . for example i want to print record number 2 , 34 , 100 , 501 and
590 on a single page. even i tried to select record number 2,34,100,501
and
590 but i was give the print on different page for each record. but i want
to
print them on a single page. i hope u understand it very well , what i am
saying.Thanks