Have you ever created a chart or table in Excel and you want the first row with the header information (like Name, Address, Phone number, etc.) to stay visible while you scroll through the pages and pages of entries in your spreadsheet? This is easily done by freezing the row(s).

• Open Excel
• Enter your column headings in the appropriate row.
• Highlight the row below the one your want to freeze by clicking on the row heading number.
• Select Window from the menu bar
• Choose Freeze Panes
• Now as you scroll through the document, that row should remain visible at the top.

Now what if you want that row to print at the top of every page? That won't happen if you just freeze the panes as we did above, but you can do this easily by doing the following.

• Select File
• Choose Page Setup
• Click the Sheet tab
• Where it says "Rows to Repeat at the Top" choose the button in the right side of that box
• The window will shrink and you will be able to scroll to find the row you want to repeat and then select that row(s) (by clicking on the row heading number)
• You will see that row description turn up in the box and you will need to click the button on the right side of that box again.
• Then click OK
• Now when you print, that row will print at the top of every page.

These same directions can be followed to select Columns to freeze or repeat in printing.