Controlling Header & Footer ?

[Excel-ent]

Dear Experts,

I have an excel sheet of 5 Pages, each of which has a Header and Footer. While printing, I do not need the Header to be available in the 5th Page, which is a Summary Page. Is it possible to control Headers in each page.

I am currently printing the first 4 pages, then change the header to the requirement and print the last page and then Undo to make it available in all the pages. (poor me !)

I am using Windows 98 and office 2000.

Any suggestions would be most appreciated.

Regards,

Shan

 

[P Sitaram]

Try Custom Views under View Menu