ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print titles (https://www.excelbanter.com/excel-discussion-misc-queries/1739-print-titles.html)

Roger Bedford

Print titles
 

In Excel 2002 I would like to have the first two rows show only once at the
top of the first page of any printout. I used $1:$2 but it doesn't work as it
did in my old Excel 5.

Any suggestions would be greatly appreciated.

Roger

Gord Dibben

Roger

To have the top two rows print only on the first page, do not set "Rows to
repeat at top".

Leave it blank or they will print on every page.

Gord Dibben Excel MVP

On Sun, 12 Dec 2004 05:44:48 GMT, (Roger Bedford) wrote:


In Excel 2002 I would like to have the first two rows show only once at the
top of the first page of any printout. I used $1:$2 but it doesn't work as it
did in my old Excel 5.

Any suggestions would be greatly appreciated.

Roger




All times are GMT +1. The time now is 12:34 AM.

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