ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to set Header Row to repeat on each page (https://www.excelbanter.com/excel-discussion-misc-queries/68961-how-set-header-row-repeat-each-page.html)

braitman

How to set Header Row to repeat on each page
 
Hi folks.

Here's my issue:

I have a very long spreadsheet with about 5000 rows and about 20
columns. One row at the top of the document is devoted to "header"
information, in other words, what each column is, i.e., Name, Title,
etc.

I'm going to print out this document and would like to have that top
row repeat at the top of each page. It's not a true header (at least
not what I've been able to tell from the Excel Header & Footer screen),
so I'm stuck for a solution.

I'm using Excel 11.2 with a PowerBook G4 OS 10.4.4.

Thanks!

Stephen


Anne Troy

How to set Header Row to repeat on each page
 
Here's how, Stephen:
http://www.officearticles.com/excel/...ft_exce l.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"braitman" wrote in message
ups.com...
Hi folks.

Here's my issue:

I have a very long spreadsheet with about 5000 rows and about 20
columns. One row at the top of the document is devoted to "header"
information, in other words, what each column is, i.e., Name, Title,
etc.

I'm going to print out this document and would like to have that top
row repeat at the top of each page. It's not a true header (at least
not what I've been able to tell from the Excel Header & Footer screen),
so I'm stuck for a solution.

I'm using Excel 11.2 with a PowerBook G4 OS 10.4.4.

Thanks!

Stephen





All times are GMT +1. The time now is 03:10 PM.

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