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.
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, for example. And 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, for example.
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.
Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 - Printing Spreadsheets - Repeat Rows or Columns on Each Printed Page.
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.