how to print

R

reneabesmer

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
 
R

Ragdyer

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.
 
Top