This question was posted in 2006. Has the answer changed at all since then?

Q: In WORD you can type away on your document, and the header and footer
will
always be there so you can see how it appears (but you can't modify it
without actually going into it)...

Anyway... is there a way to have the header appear in Excel?

A: Only in print preview however next version will have a header visible if
you
are in page layout view