How to Print Headings in every page in Microsft Excel


Many time we create a excel document but when print it,we need top header on every page but excel print only first page.in this article we will discuss how to print header/title on every page.

1-First open you'r exciting excel sheet.
Excel tips 1
2-Now there is lots of page but you print Brown color area on every page.

3-Go to page layout then go page layout and click print titles option.
Excel tips

4-Then click rows to repeat at top option and select the rows which you want to print on every page and then click ok.

5-If you print column to repeat at left option and select the columns which you want to print on every page and then click ok.

6-Now your document is ready to print.



Related Articles

Microsoft Office 2010 New Features and Price

Microsoft launches new version of its Office suite, Office 2010. The publisher has made many innovations, such as integrating video on presentation material, and management of social networks from the Outlook email. A light version ("Office Web Apps"), available free online, is also proposed.

Changing the settings of an email account in Outlook 2010

Several reasons may require you to change settings for an email account: The password assigned by your ISP changes, the mail server or security settings you want to change or customize settings, such as how your name is presented to other users. Let us see in detail how to modify the settings of an email account in MS outlook 2010.

More articles: Microsoft office

Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: