Anne,
Thank you so much. You've answered questions that have plagued me for years!
This site is so helpful!
B.Kundla
"Anne Troy" wrote:
1. If it only appears on one page, it's not really a header. Just place it
in the top of your worksheet (I use textboxes).
2. Try a find and replace. Find K and Replace with 0. You can record a macro
that makes K = 0, and another that makes 0 = K. See:
http://www.officearticles.com/excel/...soft_excel.htm
Then take the code that gets created from it and put it in your
Workbook_BeforePrint event. Let us know if you need more help with that.
************
Anne Troy
www.OfficeArticles.com
"B.Kundla" wrote in message
...
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