Printing column label on every page.

  • Thread starter Thread starter Raymond
  • Start date Start date
R

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.
 
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
 
Back
Top