Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Two questions
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
So happy to help. :)
************ Anne Troy www.OfficeArticles.com "B.Kundla" wrote in message ... 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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A couple of questions... | Excel Discussion (Misc queries) | |||
Where can I post Macro questions? | Excel Worksheet Functions | |||
Questions??? | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Puzzling Format Questions | Excel Discussion (Misc queries) |