printing headings on every sheet

[Guest]

I have created a spreadsheet thats 8 pages long and have merged cells 1A to 1D for a heading and then have sibheadings in each column. I would like them to print on each page how do i do this? please help send answers to the e-mail address provided. cheers

 

[Arvi Laanemets]

Hi

Files.PageSetUp.Sheet - enter $1:$2 into field 'Rows to repeat at top'


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

I have created a spreadsheet thats 8 pages long and have merged cells 1A

to 1D for a heading and then have sibheadings in each column. I would like
them to print on each page how do i do this? please help send answers to the
e-mail address provided. cheers

 

[Bob Phillips]

Put the headings on Row 1, and then in the File>Page Setup>Sheet put $1:$1
in Rows to Repeat at top box.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I have created a spreadsheet thats 8 pages long and have merged cells 1A

to 1D for a heading and then have sibheadings in each column. I would like
them to print on each page how do i do this? please help send answers to the
e-mail address provided. cheers