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)...
Tame your computer - rapid repetition
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.
- 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...
Unless stated otherwise, these tips were written for Microsoft Office 2010.
13 November 2017