Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen.  This month I’ll show you how you can choose rows or columns to appear on every page when you print.

  1. Click the Page Layout tab on the ribbon.
  2. Click the Print Titles button in the Page Setup section of the ribbon.
  3. To get rows from your spreadsheet to appear at the top of every printed page, click in the Rows to repeat at top box.  Then, with the Page Setup window still open, click on the row of your choice.  You can select multiple rows by clicking on the first row and dragging to select a range of rows.
  4. To get one or more columns to print on the left side of each page, click in the Columns to repeat at left box, then click on the column or columns you want to have printed on each page.

These instructions assume you are using Excel 2007 or 2010.  If you are using Excel 2003 or older, go to the File menu and choose Page Setup. In the Page Setup window go to the Sheet tab.  From there you can follow steps 3 and 4 above.

Here are a couple of additional details.  The rows (or columns) to repeat have to be adjacent, for example you can’t select rows 1 and 3, but not 2.  Also, you only select entire rows (or columns) to repeat.

[Facebook] [LinkedIn] [StumbleUpon] [Twitter]