Printing certain rows of a spreadsheet

[bhansen24]

Hello All,

I am having trouble printing my excel spreadsheet. I want to print the column headings and also a certain row below, say row 7 together. However, when I select the heading row and that row and try to print my selection it prints on separate pages. Is there a way to print all on one page?

In the general forum they talked about using macros and VBA. I am not sure how to do so. Any help will be greatly appreciated.

[jolivanes]

Have you tried hiding the rows you do not want to print?
Attached a test file to try.
Select the rows you don't want printed with your mouse and click on OK on the Inputbox.
For multiple ranges, hold down your Ctrl key.