ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I print frozen panes to appear above print selection in Ex (https://www.excelbanter.com/excel-discussion-misc-queries/81057-how-can-i-print-frozen-panes-appear-above-print-selection-ex.html)

Snr Franco

How can I print frozen panes to appear above print selection in Ex
 
I have selected a print area in Excel but I want the panes frozen at the top
of the page (which contain a description of the various columns) to be
printed as well. How do I do it?

Dave Peterson

How can I print frozen panes to appear above print selection in Ex
 
Include those rows in your print range.

If you mean you want those same headers to appear on each of the printed sheets,
then file|page setup|sheet tab and use "rows to repeat at top".

Snr Franco wrote:

I have selected a print area in Excel but I want the panes frozen at the top
of the page (which contain a description of the various columns) to be
printed as well. How do I do it?


--

Dave Peterson


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com