Print headings/labels on every page

G

Guest

I'm trying to print 1 row and 3 column headings on every page. When I try it
under file/page setup/sheets I select the row to repeat at top then columns
to repeat at left. When I try to print or preview I get the error message
"print titles must be contiguous and complete rows or columns." What can I do?
 
G

Gord Dibben

You can move the columns around so's they are contiguous.


Gord Dibben MS Excel MVP
 
G

Guest

Mr. Dibben, thanks for your reply. I tried to make sure that the columns were
contiguous with each other and the row. It didn't work so I must still have
it set up wrong. Would you mind if I sent you an example of what I am working
with so that you can see what I have wrong? I don't want to just post it.
Thanks
 

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 column label on every page. 2
Cannot repeat column headings 1
Print titles must be contiguous and complete rows or columns 18
Print same column headings on each page 3
Why is the Print Titles option in Page Setup:Sheet greyed out? 2
Repeating first Row AND first column on every page 1
Print row labels that are continous 1
Print titles must be contiguous and complete rows or columns 1

Top