Home > IT Answers > Microsoft Windows > Print one row on all pages in Excel
RoadDust
390 pts.
 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

Software/Hardware used:
ASKED: April 9, 2009  1:43 PM
UPDATED: April 9, 2009  3:02 PM
RELATED QUESTIONS
Answer Wiki:
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<b> File > Page Setup</b>, clicking on the<b> "Sheet"</b> tab, and under <b>"Print titles"</b>, choose <b>"Rows to repeat at top"</b>. Does this work for you? Thanks, Jenny Community Manager
Last Wiki Answer Submitted:  April 9, 2009  1:52 pm  by  JennyMack   4,265 pts.
All Answer Wiki Contributors:  JennyMack   4,265 pts. , philpl1jb   44,180 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi Jenny,

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

Dustin

RoadDust
 390 pts.
 

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.

Technochic
 56,975 pts.