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 when they no longer have to use sticky tape or can stop copying and pasting the data, I thought it was time to write about how to specify rows and columns to repeat on each printed page using Excel 2007 onwards.
Here’s how:
- Click on the Print Titles button in the Page Setup group on the Page Layout tab.
- Click in the Rows to repeat at top box.
- With the Page Setup dialog box open, click on any of the cells in the row(s) you want to repeat on each page.
- Click in the Columns to repeat at left box.
- With the Page Setup dialog box open, click on any of the cells in the column(s) you want to repeat on each page.
- 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'd have fixed that by now...
Related tips:
Print the lines between rows and columns to make reading easier
Change the starting page number in the header or footer
Fit a worksheet on the printed page
Print a specific row or column as your title on every page of a printed worksheet
Unless stated otherwise, these tips were written for Microsoft Office 2010.
13 November 2017
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk