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.
Hi Hans - I go to page layout, print titles, and it won't let me print anything in the repeat rows or repeat collumns boxes. How do I get this back?
Does the problem persist if you quit Excel completely and restart it? If you restart your computer?
- Thank you so much for this suggestion. It worked! I was having the same problem and closing all workbooks and excel allowed me to do this. This was a career saving moment!
