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 |
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