[Solved] Printing: Freeze Panes & Print

  • What's the easiest way, VBA or otherwies, to print part of a worksheet when some cells are frozen.

    What I mean is, from row 5 upwards is frozen. I want to print part of the worksheet way down at around row 300, but I want rows 1-5 to be included on the printed page.

    Can anyone help?

    Thanks in advance.

  • Use File / Page Setup / Sheet and specify the Print Area and/or Print Titles (Rows and/or columns to repeat on each page) to get what you need.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!