Print one row on all pages in Excel

390 pts.
Tags:
Microsoft Excel
Microsoft Excel 2003
Hi, Does anyone know of a way to print one row on all pages in Excel, kind of like a header? Thanks, Dustin

Answer Wiki

Thanks. We'll let you know when a new response is added.

In the older versions of Excel – File – PageSetUp – Header/Footer tab.

I’m sure it’s different in 2007

Phil
- – - – - – - – - – - – - – - – - – - – - – - – - – - – - – - -

Hi RoadDust,

If I’m understanding what you’re asking, you can have your header rows repeat on every page by going to File > Page Setup, clicking on the “Sheet” tab, and under “Print titles“, choose “Rows to repeat at top“. Does this work for you?

Thanks,
Jenny
Community Manager

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RoadDust
    Hi Jenny, Yes that's exactly what I needed. Thanks for yours and Phil's help. Dustin
    390 pointsBadges:
    report
  • Technochic
    Thanks Jenny! Great tip! For Excel 2007 I found it on the ribbon bar for page layout. I clicked on the arrow for Page setup and then found the sheets tab you mentioned.
    57,010 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following