How can I display a particular row on every page?

M

mnpremo

I'm trying to view the heading row on every page in my Excel worksheet. How
can I do that? Thank you.
 
J

JulieD

Hi

if its in the worksheet its self, click on A2 and choose window / freeze
panes
if you want the row to appear in the print out
choose file / page setup - sheet tab, rows to repeat at top and click on the
row number 1

hope this helps
Cheers
JulieD
 
G

Gord Dibben

If you're talking about printing the header row on each printed page........

File>Page Setup>Sheet>Rows to repeat at top.

Enter 1 or point to the row.

Otherwise, go with JulieD's freeze panes.

Gord Dibben Excel MVP
 
Top