Thursday, December 29, 2011

In Excel How To Repeat First Column In Every Pages




Go to page layout - page setup



In Page setup Dilog Box Just click On Sheet Tab.



In Print Area- Just Select Which Area Do You Want To Take Print Out.
In Column To Repeat At Left - Just Select Which Area Do You Want To Repeat.

Note-(If You Want To Repeat Row Header, In Row To Repeat At Top- Just Select Which Area Do You Want To Repeat).



Then See The Print Preview ( And Change The Margin If Its required )



You Can See SlNo And Name Will Appear In Every Pages.

No comments:

Post a Comment