Excel tips-How to print headings/Titles in every page

Posted Date: 03-Jul-2010		Category: Microsoft Office
Author: Brajamohan panda	Member Level: Gold
Rating:	Points: 10 (Rs 4)

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.

Did you like this resource? Share it with your friends and show your love!

Related Resources:

Read related articles: MS Excel MS office Microsoft products

Responses to "Excel tips-How to print headings/Titles in every page"

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

Feedbacks

Post Comment:

Notify me by email when others post comments to this article.

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:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
Website:	We will link to your website, if the comment is worth keeping!
	Type the numbers and letters shown on the left.

	Next Resource: How to save PDF from Microsoft office
	Previous Resource: How to open Docx files in Word 2003 or Word XP?
	Return to Resources
	Post New Resource
	Category: Microsoft Office