Print same header at top of each printed page

G

God's Kid

I am looking to print the same header at the top of each printed page. I
have gone to File/Page Setup/Sheet. It then says rows to repeat at top
and I have put in the row number, it then says "reference not valid".
Is there a syntex problem or Am I totally wrong?
 
D

dominicb

Good evening God's Kid

After the first read of your post I couldn't figure out what might b
wrong, but after reading it more literally, I figured it out.

Excel expects you to click on the ref edit icon on the right of the bo
and select a row to print on every page. Once you do this the syta
becomes something like this:

$1:$2

HTH

Dominic
 

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
How print header row at top of each page? 4
printing a header in Excel 2
Printing - different rows at top for each page 1
1st 2 rows of wksht show up @ top of each page of the wksht 2
Printing Row 1 at top of each page 2
Printing labels at the top of multiple pages 4
repeat rows at top of page 4

Top