Printing column label on every page.

[Raymond]

I have several column labels like date, hour, ect on one row on the top. I
want to print this row label on every page. However I can't seem to do that
because on the instruction option is grayed out. Here is the instruction.
The last two instruction sentences are grayed and they give me no choice to
do it.

1.. Click the worksheet.
2.. On the File menu, click Page Setup, and then click the Sheet tab.
a..
1.. Do one of the following:
2.. Print row and column headings
3.. a.. Select the Row and column headings check box, and click Print.
4.. Print row and column labels on every page
1.. To print column labels on every page, under Print titles in the Rows
to repeat at top box, enter the rows that contain the column labels, and
then click Print.
a.. To print row labels on every page, under Print titles in the Columns
to repeat at left box, enter the columns that contain the row labels, and
then click Print.

 

[Jim May]

Full Options are not available sometimes for a reason; particularly when
certain
options/settings are not available dealing with the Print feature, it's
because the activesheet is completely Blank. Select a single cell (say a1)
type test; What print options that were grayed-out are perhaps no longer
grayed-out..
HTH

 

[Myrna Larson]

See if the following article applies. The problem described here is that you
have several worksheets grouped.

http://support.microsoft.com/default.aspx?scid=kb;en-us;125640

if that doesn't help, go to support.microsoft.com and search for Excel print
titles