I want row 1 to show on the top of every printed page

G

Guest

I want row 1 to show up at the top of every printed page. Is there a way to
change the formatting for that row to do that?
 
G

Guest

Go to page set-up. Go to the "sheet" tab under print titles select your top
row to go into the "rows to repeat at top". That should work!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert automatic page numbering into a cell, not a header or foote 1
Why does row one always appear at the top when page down 1
Row Scrolling with a Page 1
Printing - different rows at top for each page 1
header row stay on scrolled display and printed pages 1
Arggh! Each row prints on separate page 2
alternate row shading on filtered data 2
Excel: Repeating Row 1 Content at top of all printed pages 2

Top