Printing selection of rows

[lemel]

Trying to print only selected rows in a workbook and when i have gon
into the print menu and told it to print the selection it puts one ro
on a seperate page. for example if i select 6 different rows and tel
it to print selection it print 6 seperate pages with 1 row on eac
page

 

[Ron de Bruin]

Hi Lemel

You must use a macro for this
http://www.rondebruin.nl/print.htm#non-contiguous

 

[Gord Dibben]

Or hide rows you don't want printed.

Gord Dibben Excel MVP

 

[Ron de Bruin]

Or hide rows you don't want printed.

For the OP there is also a example on my print page
http://www.rondebruin.nl/print.htm#Hide