How to bring excel row in header of every pages

Excel is common most use accounting database managing application. In excel application has option to repeat excel row at top on every pages. Now I am going to show how you will do this. 

• First open your completed excel file

• Then go to page or print preview to view your page status

•  

• We see in preview there is no header on second and third page but it has only on first page. 

• Now to page layout section from menu bar then click on the arrow to go page setup dialogue box

  

• Here will come a dialogue box & you will find several option in this box

• I will show the row repeat option only so click on sheet option

• Then click on row repeat at top option

•

• In this section has click point right side of row repeat at top box we will click on this box to selection our target row to make visual on every pages. 

• Just select your target row I have select as I want, After selecting target row click on same  option what we did before here

• Then we will found main dialogue box again 

• Now just click on ok & go preview option you will found the target row will be repeated on every pages. 

• Now enjoy your excel worksheet will be easy to find everything when print or view

Thank for your time if you like or think it is helfull pls share it to others to visit my site.