Excel+Repeat+Rows+or+Columns+on+Each+Printed+Page

Excel Repeat Rows or Columns on Each Printed Page

When printing a multi‐page Microsoft Excel 2003 spreadsheet, it may be beneficial to repeat certain rows or columns on every page.

For example, the first few rows of a spreadsheet may contain text describing the spreadsheet and what is contained in each column.

For example by including these rows and/or columns, someone reading the 11th page of a 47 page spreadsheet will not have to refer to page 1 in order to see that column 3 means accounts payable.

And, for example someone reading the 3rd page of a wide spreadsheet will not have to refer to page 1 to see that row 15 represents income for the weeks of March 1‐14

Here is how you do it :‐

1.Click ʺFileʺ ‐ ʺPage Setupʺ.

2. When the ʺPage Setupʺ multi‐tabbed dialog box appears, click the ʺSheetʺ tab.

3. To repeat rows at the top of each page, click on the miniature spreadsheet button next to ʺRows to repeat at topʺ.

A floating toolbar, ʺPage Setup ‐ Rows to repeat at topʺ will appear. Select the row(s) that you want repeated and their numbers will display in the dialog box. Click the button at the end of the toolbar once you have made your selection. The row(s) will then appear in the ʺPage Setupʺ dialog box.

4. Likewise, to repeat columns, click on the miniature spreadsheet button next to ʺColumns to repeat at leftʺ.

The instructions for selecting columns are similar.

__**Note**__ that you can choose to repeat just rows, just columns, or both.

5. When you are done, click ʺOKʺ to close the dialog box.

Simple