Print Column Headings


G

Guest

I am trying to print my column headings (the contents of row 1) on each page,
but Excel is not having it. I have the pane frozen, so that row 1 is always
visible on the screen when I scroll. In the past, this has also given me the
column headings on printouts, but not this time. "Help" tells me to use the
"Rows to repeat..." setting in "Sheet" under print setup. However, the option
is greyed out. What am I doing wrong?
 
Ad

Advertisements

D

Dave Peterson

Don't go through the print preview dialog.

Go through File|page setup|sheet tab.
 
Ad

Advertisements


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

Top