1. Put your cursor in Column A of the first row of data, and hit
Window--Freeze panes. I also strongly suggest you put your headings in ONE
ROW ONLY. If you need more than one LINE for your heading, use ALT+ENTER to
get a paragraph return in your cell.

2. No.

3. Use Data--Autofilter to get just "this months" data.
*******************
~Anne Troy

www.piersontech.com
www.mrexcel.com


"timerigger" wrote in message
ups.com...
I'm creating a spreadsheet that is basically a list of items sold for
the month. Each item entered is unique. There are various cloumn names
such as "stock number", "customer name", "profit", etc.

How do I set it up so that the first few rows that I'm using for column
names, etc are repeated on each page?

Is it possible for excel to count the items automatically and only
print the items as they are entered?

This month I might sell 25 individual items and next month I might sell
150, I'd like to be able to have the spreadsheet automatically for the
size of the data.

Thanks!
tim