ExcelBanter - Headers in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Headers in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/264052-headers-excel.html)

Beancounter[_2_]

Headers in Excel

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

Gord Dibben

Headers in Excel

Excel 2007 has the page layout view allowing you to see the header/footer
on screen.

So, assuming "Next version" refers to 2007, no change to the answer.

Gord Dibben MS Excel MVP

On Tue, 18 May 2010 11:58:15 -0700, Beancounter
wrote:

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

bala_vb

Quote:

Originally Posted by Beancounter[_2_] (Post 954443)

by default, it is not possible to view header and footer in excel 2007.
in excel 2007, goto view and choose page layout

or

use this

activesheet.range("A15")= Pagesetup.Leftfooter
activesheet.range("B15")= Pagesetup.rightfooter

it shows the header and foother by default.

all the best

All times are GMT +1. The time now is 01:37 AM.