Ignore blank rows while printing

Hey guys,
I need small help.

In sheet INVOICE cell B11:B29 i write my product codoes to make invoices.
However mostly i write maximum of 2-3 codes in that range.
Thus others cells remain blank.

So when I print, there is a big gap since rows are empty.

Is it possible to ignore the blank rows while printing?

Maybe leave a gap of 2-3 rows after the last product code and print

That would make my print out compact.

i have attached my workbook.

Hi

You could try hiding rows on the invoice tab then un-hiding whenever you need to go beyond 2-3 rows. I cannot test if there are issues with doing this given the format of the spreadsheet download.

Cheers

Hey Fox,
thhank yyou for your reply.
I will try and keep you updated

Hey SHG,

THank you for your reply.
I will try this method as well and get back