Why I can’t choose rows and columns to repeat on print outs in Excel?
Set the rows and columns to repeat by clicking on “Print Titles” within the “Page Layout” ribbon.
If your worksheet spreads over more than one printed page, you can define rows and columns to repeat. That way, the header row or column will be printed on each page. Large tables are much easier to read.
The problem: Often the fields for defining the rows and columns to repeat are greyed out. This occurs, when you just press Ctrl + p and go through the print preview.
Instead, you have to go through the “Page Layout” ribbon and set the print range there.
- Click on “Print Titles” within the “Page Setup” section on the “Page Layout” ribbon.
- Select the rows or column you want to be repeated.
- Confirm by clicking on “OK”.
For more information about printing Excel sheets please refer to our large print guide.