About Us

bala_vb · 01:46 PM

Quote:

Originally Posted by Beancounter[_2_]

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

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
lookup using column headers and row headers	Memphus01	Excel Discussion (Misc queries)	1	April 13th 09 04:57 PM
Headers in Excel	Lynne	Excel Discussion (Misc queries)	6	August 20th 08 09:49 PM
headers in Excel	DouglasGrantPhD	Excel Discussion (Misc queries)	4	August 18th 07 03:46 PM
Headers in Excel	rab	Excel Discussion (Misc queries)	1	March 23rd 05 12:59 AM
Excel Headers	Angelo	New Users to Excel	1	March 15th 05 10:52 PM

Menu

About Us