Forum Discussion
Solved
repeating rows at top of printed pages
When I do print preview and select page setup and sheet, I am not allowed to make an entry of which rows or columns to repeat on each page.
Does the problem persist if you quit Excel completely and restart it? If you restart your computer?
Print Titles and Print Area are disabled when you activate the Page Setup dialog from Print Preview.
Activate the Page Layout tab of the ribbon.
Click 'Print Titles' in the Page Setup group.