header row stay on scrolled display and printed pages

G

Guest

How do I get a header row to stay at the top of the displayed rows, even as I
scroll down the rows on the spreadsheet and how do a get the heder row to
display at the top of every printed page?
 
J

JulieD

Hi

to get to to stay at the top of displayed rows, click underneath the header
(ie in A2) and choose window / freeze panes
to get it to print on each page choose file / page setup - go to the sheet
tab, click in the box next to rows to print at top, click on row number 1
click Ok

Cheers
JulieD
 

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

printing a header in Excel 2
How print header row at top of each page? 4
Insert automatic page numbering into a cell, not a header or foote 1
Row Scrolling with a Page 1
row placement & alternating highlighting 5
Row 1 HEADERS on EVERY printed page 2
Create an always visable header row that does not move when scroll 1
Sorting issue with frozen panes 11

Top