Limit header to 1st page only

[hsonline]

How can I keep the header from appearing on every printed page of my spreadsheet? I only want the header on page 1.

Thanks.

 

[SimonP]

Select File > Page Setup

Select the 'Sheet' tab

Delete the cell references in Print Titles > Rows to repeat at top

 

[hsonline]

Thanks. I was looking for a solution in "headers and footers", but this works just as well.

 

[Mala]

REPLY:
Excel does not provide the facility to limit printing the header specified in the page setup to the first page. Two possible workarounds are:

1. Specify the header in page setup, print Page1 of the print area, go back to the page setup and delete that header and then print the remaining pages. (Not very brilliant, is it?)

2. Insert additional row(s) above the print area, and in this range, type and format the header you wish to appear in the output and include this range in the area to be printed. Take care that this range is not included in 'Rows to repeat at top'.