Print one row on all pages in Excel
Home > IT Answers > Microsoft Windows > Print one row on all pages in Excel
RoadDust
390 pts.
0
Q:
Print one row on all pages in Excel
Excel 2003, Microsoft Excel
Hi,

Does anyone know of a way to print one row on all pages in Excel, kind of like a header?

Thanks,
Dustin
ASKED: Apr 9 2009  1:43 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
JennyMack
3330 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: Apr 9 2009  1:52 PM GMT by JennyMack   3330 pts.
Latest Contributors: Philpl1jb   24610 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

RoadDust   390 pts.  |   Apr 9 2009  2:00PM GMT

Hi Jenny,

Yes that’s exactly what I needed. Thanks for yours and Phil’s help.

Dustin

 

Technochic   40210 pts.  |   Apr 9 2009  3:02PM GMT

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.

 
0