I am working on a pivot table in Excel 2010 that i split into separate worksheets within one work book.

There are 400+ worksheets and some have 2 or more pages. I want to get print titles to repeat on every page. There is a row (C) that needs to be repeated on every page in every worksheet in the work book.

If I select all worksheets, the Print Titles selection is grayed out, so I can't choose it.

If I record a macro on one, and run it on all worksheets, my header and footers disappear.

Is there another way to do this?