Microsoft Excel Printing question

I have a rather large table in Microsoft Excel. It’s the kind of table where there is a list of stores on the y axis and a list of suppliers along the x axis and a little notation where the a given store intersects with a supplier that they use. Because it will take several pages to print this file in some sort of readable font size, I’d like the list of stores in column A (the y axis) to appear on every printed page. How do I make it do this?


File | Page Setup… | Sheet | Print titles | Columns to repeat at left: $A:$A

What larsenmtl said, but then leave out that column when you set your print area. The same thing can be done if you need to see the first row(s) on every page.

Flippn’ sweet!
I’m going to show everyone in my department how to do this!

Chicken kisses.