Couple of methods.

Both involve copying the data to a new worksheet.

See Ron de Bruin's site for details

http://www.rondebruin.nl/print.htm#non-contiguous


Gord Dibben MS Excel MVP

On Fri, 29 Sep 2006 11:01:02 -0700, tikchye_oldLearner57
wrote:

hello community

Is there a way for me to put 2 selected range of data to be printed out into
a single page. When I used the "Print Selection", the two area that I
selected appeared to be in different page.

thanks community for the assistance :)