ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print column headers on select pages only (https://www.excelbanter.com/excel-discussion-misc-queries/59497-print-column-headers-select-pages-only.html)

RonJ

Print column headers on select pages only
 
I want to be able to print column headers on many pages of a document, but
NOT on ALL of them.

Duke Carey

Print column headers on select pages only
 
Sorry - it's an all or none option, unless you print those you want with the
header, delete the header, and then print the ones you want WITHOUT the header


"RonJ" wrote:

I want to be able to print column headers on many pages of a document, but
NOT on ALL of them.


Dave Peterson

Print column headers on select pages only
 
Maybe you could use a macro that prints each page the way you want.

You could record a macro while you print the first page (add the header). Then
remove the header/rows to repeat at top, print the next, continue until you're
done.

Then just execute that macro when you want to print again.

RonJ wrote:

I want to be able to print column headers on many pages of a document, but
NOT on ALL of them.


--

Dave Peterson


All times are GMT +1. The time now is 08:50 PM.

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