Is there a way for a row functioning as a header to freeze, but then be replaced by another header row as it scrolls on to screen?
In my example I've got a section called "Benefits", then about 20 rows of information, then when the header "Costs" appears, I'd like for it to replace the frozen header at the top where "Benefits" was.
Is this possible to do in Excel 2010?