Tame your computer - rapid repetition



In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to 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 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:

  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'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

Roem Limited

Independent, innovative software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.

Roem Limited directory information