ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing header row on each page (https://www.excelbanter.com/excel-discussion-misc-queries/148171-printing-header-row-each-page.html)

GKW in GA

Printing header row on each page
 
Is there a way to repeat the header row (prferably rows) on each page. I'd
like to have it work kind of like 'freeze panes' does when viewing

Elise148

Printing header row on each page
 
Go to Page Setup, choose the Sheet tab, click in the "Rows to repeat at top"
option and then highlight the rows you want to repeat on each page...

"GKW in GA" wrote:

Is there a way to repeat the header row (prferably rows) on each page. I'd
like to have it work kind of like 'freeze panes' does when viewing



All times are GMT +1. The time now is 01:20 PM.

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