Repeat Spreadsheet Column Headings at Top of Subsequent Pages

[prezlyn]

Hello,

I want to repeat spreadsheet headings at the top of every page. However, I am getting the "Print titles must be contiguous and complete rows or columns." I have tried the following: Page Layout - > Print Titles ->Sheet : Cell errors as : chose <blank> to no avail. Any suggestions?

Thank you,
Cristine

 

[prezlyn]

Ok, that works. Can you explain why it does?

 

[Fluff]

$1:$4 is treated as a contiguous range, whereas $1:$1,$2:$2 is treated as 2 separate (ie non contiguous) ranges

 

[prezlyn]

Thank you!!!

 

[Fluff]

Your welcome