printing with freezed columns

[nightcrawler23]

hi all,
I have a table which spans across more than 20 columns.
the first 3 columns are frozen. i want to print in A4 size 7 columns of the table where the last 4 columns keep changing

For eg: my first page shows columns A-C,D-G, 2nd page shows columns A-C,H-K, 3Rd page shows columns A-C,L-O.

any suggestions.

 

[Trevor G]

Select your pagesetup options and in the Sheet tab you can set columns to repeat at left, then all you do select the Columns.

 

[nightcrawler23]

Thanks trevor,
But i find the print title options greyed out. Whats the reason?

 

[Trevor G]

Don't go in via print preview use the Page Setup.

 

[nightcrawler23]

Thanks a lot Trevor. it was great help.