Tip of the week # 527
13 November 2017


Print specific rows and columns on each page (Microsoft Excel) *

Many, many moons ago (24 March 2006 to be precise) I wrote a tip on how to print a specific row or column on every page of a printed worksheet. This is particularly helpful when your worksheet is too big to fit on one page. After all, you can have 1,048,576 rows and 16,384 columns!

The instructions were written for Excel 2000, but I bet you've upgraded since then and the steps have changed a bit. As I still meet delegates who get very excited they no longer have to use sticky tape or can stop copying and pasting the data, I thought it was time to write how to specify rows and columns to repeat on each printed page using Excel 2007 onwards.

Here's how:

  1. Click on the Print Titles button in the Page Setup group on the Page Layout tab.
  2. Click in the Rows to repeat at top box.
  3. With the Page Setup dialog box open, click on any of the cells in the row(s) you want to repeat on each page.
  4. Click in the Columns to repeat at left box.
  5. With the Page Setup dialog box open, click on any of the cells in the column(s) you want to repeat on each page.
  6. Click OK or press ENTER.

By the way, you still cannot do this if you accessed the Page Setup dialog box from Print Preview. I would have thought they would have fixed that by now.

Related tips:

Tip # 495: Print the lines between rows and columns to make reading easier (tip_495.php)
Tip # 446: Change the starting page number in the header or footer (tip_446.php)
Tip # 404: Fit a worksheet on the printed page (tip_404.php)
Tip # 148: Print a specific row or column as your title on every page of a printed worksheet (tip_148.html)


* Unless stated otherwise, these tips were written for Microsoft Office 2010.