Labels

Monday, February 11, 2013

How to Add headers and footers to a worksheet in Excel 2010

I have a problem in worksheet in excel 2010 to add headers and footers, then I am searching solve in my problem.. at last i was solved my problem follow, below the step

Goto Page Layout
Page Layout On excel 2010

Click Print Titles 
Print Titles - excel 2010

Popup window open on your screen
Select Header/Footer tab

you can go with Custom Header

 


















A new popup open in your screen

now you can add your text or images

Preview in Print Preview.

That's it