Page Layout (Page Break Preview) is not working with hidden rows in excel.

Dear All,

I have more than hundred rows in excel file. I need to print first page with few rows hidden within it.
But When I try to view print preview, it display only few rows not full page because few rows is been hidden
in the first page.

How can I print one full page with only displayed rows and not with hidden rows?
Do we have any vba code for that?

Can I adjust Page Break Preview even with hidden rows within it?

Please help me.

Thanks in advance & Regards,
ebincharles

Can I use copy the displayed rows and paste to other sheet for printout?

I think this will work. But if have more than thousand rows it is quite difficult.

May be there is other way I searching.

Regards,
ebincharles

I think it is difficult to solve this.
After I posted, I was trying to solve this meanwhile, but I do not find anyway to
solve this.

Only I can do this if I delete the hidden rows.
But If I delete I cannot retrieve that rows again. So I think it is quite difficult.

regards,
ebincharles