How to view Header or Footer on screen in Excel

[Carolyn]

I would liek to know if there is any way of being able to view the header
and/or footer in an Excel document on screen?

 

[Dave Peterson]

File|Print preview???

Excel doesn't work like MSWord.

(at least through xl2003, not sure about xl2007)

 

[Carolyn]

Thanks. Yeah, i know about being able to see it in Print Preview or when the
document is printed, but was wondering if there is a way of viewing it on
screen when working on the document like Word?

 

[Dave Peterson]

Not in xl2003 or below.

I still don't know about xl2007.

 

[Stan Brown]

Fri, 8 Jun 2007 04:26:10 -0700 from Carolyn

I would liek to know if there is any way of being able to view the header
and/or footer in an Excel document on screen?

You mean, aside from View | Header and Footer?

If you want to see how they'll be rendered in the context of the
page, use Print Preview.

 

[Debra Dalgleish]

In Excel 2007, there's a new Page Layout view that shows the header and
footer:

http://office.microsoft.com/en-us/excel/HA100215631033.aspx

With a demo video here:

http://office.microsoft.com/en-us/excel/HA100484501033.aspx?pid=CH101030621033

Not in xl2003 or below.

I still don't know about xl2007.

 

[Dave Peterson]

Thanks for the info.

In Excel 2007, there's a new Page Layout view that shows the header and
footer:

http://office.microsoft.com/en-us/excel/HA100215631033.aspx

With a demo video here:

http://office.microsoft.com/en-us/excel/HA100484501033.aspx?pid=CH101030621033