How can I print noncontiguous rows on the same page?

[Guest]

I want to print rows 3, 9, and 18 on the same page. When I select them with
Control and try to print them, I get 3 pages. I also can "Set the Print
Area" but it also prints on 3 pages. Other than a workaround to copy and
paste to a new sheet, how can I get these 3 rows to print on one page? Thank
you. Mary

 

[Andy Brown]

Other than a workaround to copy and
paste to a new sheet, how can I get these 3 rows to print on one page?

Try hiding the rows you don't want to print. Select them with CTRL, then
Format -- Row -- Hide.

If you need to do this regularly, consider defining a custom view (see View
menu).

HTH,
Andy