Print same column headings on each page

[Guest]

In Page Setup, Sheet tab, under Print titles, both the "Rows to repeat at top" and "Columns to repeat at left" boxes are greyed out and unavailable. Any clues?

 

[Guest]

If you access Page Setup from the Print Preview, those commands aren't available. Close the Print Prieview and go in to the Setup option from the file menu

tj

 

[Peter Atherton]

-----Original Message-----
In Page Setup, Sheet tab, under Print titles, both

the "Rows to repeat at top" and "Columns to repeat at
left" boxes are greyed out and unavailable. Any clues?

.

Vino

I don't know why they are unavailable but you can use this
code


Sub ReptRows()
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
.PrintTitleColumns = "$A:$A"
End With
End Sub

Change to suit. Change name to Sub Before_Print() and copy
it into your Personal Workbook so that it is available for
every workbook if necessary.

Regards
Peter

 

[Harlan Grove]

....
I don't know why they are unavailable but you can use this
code

....

Code not needed. If the OP started off in Print Preview, then clicked on the
Setup... button, the whole Print Title section of the Sheet tab in the Page
Setup dialog will be greyed out. To set them, it's necessary to use File >
Page Setup... from the menu.