B.,

Another way to deal with your second problem would be to use a custom number
format to make all zeros show up as "k". This would let you enter
kindergarten as 0, have it come to the top when you sort, and show up as a
"k".

Highlight the cells, click Format/Cells/Number, custom, and in the box under
the word "Type:", type "0,0,k" (no quotation marks)

Eric


"B.Kundla" wrote:

1. Is there a way to make a header show only on page one?

2. I have a column that shows the grades students are in. I usually sort
them by grade, but use K for kindergarten, so kindergarten always comes up at
the end of the list, instead at the beginning where I want them. I need them
to print out as K. Is there a way to make K = 0? If so, I would rather do
this than label them all as 0 and have to change it to K when I print out my
list.

Thank you.

B.Kundla