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?
 
D

Dave Peterson

Don't go through the print preview dialog.

Go through File|page setup|sheet tab.
 

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

Rows to repeat at top... Help... 1
Column Headings 1
Excel Row & Column question 1
Column headings are numbers instead Alphabet Letters 3
Print Row Headings on left & right side 4
How to UN-check greyed-out "First Row Contains Column Headings" bo 0
Format column and row headings 2
In Excel 2003 print headings is unable to be used 4

Top