how to print

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

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A single Page print for key items 1
How to set up Excel to print wrapped columns on a page. 1
Help Reg Print 1
Print preview/page set-up is printing 100's of blank pages 2
Print worksheet 2 on back of worksheet 1, etc.... 1
Epson XP-3150 not printing 2
Duplex Printing of Workbook with multiple worksheets 2
print 5

Back
Top