Site icon Professor Excel

How to Repeat Rows and Columns on Printouts as Headers

When you print a large table, you can select rows or columns which you want to repeat on each page. This way, the data is easier to read as the heading will be printed on each page. In some cases, the fields are greyed out and therefore can’t be changed. Let’s have a look at how to handle such situation.

Steps for setting the rows and columns to repeat

Setting the heading rows and columns which should be printed on each sheet is quite easy (the numbers are corresponding to the picture above):

  1. Go to the Page Layout ribbon, click on the tiny grey arrow at the “Page Setup” group, or alternatively click on “Print Titles”.
  2. On the “Sheet” tab, you can set the rows and headers to repeat.

What if the fields for rows and columns to repeat are greyed out?

There is a very troublesome bug in Excel: If you go to File, click on Print and then Page Setup, you’ll see the same window as written above. The only difference is, that the boxes for setting the rows and columns to be repeated are greyed out. The only way of setting the rows and columns is through the Page Layout ribbon as described above and not through the print dialogue.

Exit mobile version