Format Header or Footer with Color Fonts ? Background? Ima

cc_kmoore · May 3rd, 2002, 10:06 PM

I've searched the archives but can't find an answer to this question. Does anyone know if there's a built in feature to be able to format header or footer text with color fonts? or background color? or images?

Thanks, K Moore

[ This Message was edited by: cc_kmoore on 2002-05-03 21:07 ]

Joe Was · May 3rd, 2002, 10:22 PM

File-PageSetUp-Header/Footer-Custom

Both the custom header and custom footer are limited but if you click the photo icon on the custom menu you can give the location of the picture to put in the header/footer in XP. I do not remember if the photo option is in 97 or 2000? JSW

James · May 3rd, 2002, 10:31 PM

Hi Joe,

I read a previous post from from you relating
to the speed test of 97 vs. Xp. You responded
explaning that (overhead) Xp was doing a lot more so it seemed to be slower, remember your ans. to the post? Are you happy w/ XP? I am
just curious to hear from a pro.

James

Ivan F Moala · May 3rd, 2002, 10:36 PM

Quote:

On 2002-05-03 21:22, Joe Was wrote:
File-PageSetUp-Header/Footer-Custom

Both the custom header and custom footer are limited but if you click the photo icon on the custom menu you can give the location of the picture to put in the header/footer in XP. I do not remember if the photo option is in 97 or 2000? JSW

That Option is only avail in Xp

Brian · May 3rd, 2002, 10:39 PM

You have can have more control of the headers with VBA, but don't know about colors.

Joe Was · May 3rd, 2002, 11:37 PM

I use 2000 and XP. I like XP better, the help is better. The "Speak" tools are a step in the right direction. What missing though is a tool to code or create a function by example! You still need to know way too much syntax!

With PC's having more power and speed than mainframes of just a few years ago, I am still disappointed in the lack of artificial intelligence engines in applications.

When XP finds an error in your function the auto-correct in XP is about the same as 2000, both are primitive. More can be done to improve on this now.

When coding tools like "C" programing almost killed "Basic" programing, faster more powerfull PC's brought "Basic" back to life. Now PC's are even more powerfull and VBA code that was dirty, slow and full of primitive routines in 97, can run in 2000 and XP so fast, you don't need to refine your code along the "computer economics" methods essential just a few years ago.

So the benefits of XP now is in part due to the faster more powerfull PC's. XP is great but it could be better with todays and tomorrows PC's.

I would also like to see a function library that works like "Spell-Check." That is, we should be able to add functions like we add words to a dictionary rather than the convoluted steps needed now. A more open approach to Excel code would improve the product, rather than the closed-fisted MS way.

The way MS did the public with DOS was a crime. We waited for each release, only to find few new tools that could have been released years earlier. The whole scam for profit and R&D recovery set the software application and PC development back about ten years. I feel cheated and rightly so as I know what it cost the consumer.

With Excel being the best product out, it is good, but it could be better. I see a lot of how DOS was marketed in the Excel releases and that saddens me. JSW

P.S. Almost forgot the most important missing item, a "packager." I would like to be able to put Excel developed applications on CD's and distribute them to users who do not have Excel or the current version. Like the "run-time" builders for database applications, come on MS already!

[ This Message was edited by: Joe Was on 2002-05-03 23:14 ]

[ This Message was edited by: Joe Was on 2002-05-14 06:16 ]

Jack in the UK · May 4th, 2002, 06:22 AM

picts are XP only
Colours are no go dont know of VBA to do this,never seen or read this, poss soon i guess.

XP is ok if a little childish i feel it trys to hard to help, i really dont need help uless i ask, and all this turn on and off and moving of loactions and drop down Yikes!

Win Xp is dreadful and need SP1 73MB.. else forget it... I have massive issues at wotrrk with XP in Office and Windows..

Lots to consider,. but remember i put my PC and hassle it, as do manyi work with so its what you so and what you want to do that wins the day.

MY CALL.. caution as i say with everything, poss not as they always see, remember i do this kind of stuff all day everyday..

cc_kmoore · May 4th, 2002, 10:44 AM

Thanks for the replies. No color in headers/footers and graphics only if using Office XP. This is what I told colleagues, but it just didn't seem possible that full text formatting of headers/footers is still not available.

Excellent assistance with my first trial post. I'll be back !

K Moore

May 4th, 2002, 06:22 AM	#7
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	picts are XP only Colours are no go dont know of VBA to do this,never seen or read this, poss soon i guess. XP is ok if a little childish i feel it trys to hard to help, i really dont need help uless i ask, and all this turn on and off and moving of loactions and drop down Yikes! Win Xp is dreadful and need SP1 73MB.. else forget it... I have massive issues at wotrrk with XP in Office and Windows.. Lots to consider,. but remember i put my PC and hassle it, as do manyi work with so its what you so and what you want to do that wins the day. MY CALL.. caution as i say with everything, poss not as they always see, remember i do this kind of stuff all day everyday.. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 10:06 PM	#1
cc_kmoore New Member Join Date: May 2002 Location: LA, CA, USA Posts: 2	I've searched the archives but can't find an answer to this question. Does anyone know if there's a built in feature to be able to format header or footer text with color fonts? or background color? or images? Thanks, K Moore [ This Message was edited by: cc_kmoore on 2002-05-03 21:07 ]

May 3rd, 2002, 10:22 PM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	File-PageSetUp-Header/Footer-Custom Both the custom header and custom footer are limited but if you click the photo icon on the custom menu you can give the location of the picture to put in the header/footer in XP. I do not remember if the photo option is in 97 or 2000? JSW

May 3rd, 2002, 10:31 PM	#3
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Joe, I read a previous post from from you relating to the speed test of 97 vs. Xp. You responded explaning that (overhead) Xp was doing a lot more so it seemed to be slower, remember your ans. to the post? Are you happy w/ XP? I am just curious to hear from a pro. James

May 3rd, 2002, 10:39 PM	#5
Brian Board Regular Join Date: Apr 2002 Posts: 113	You have can have more control of the headers with VBA, but don't know about colors.

May 3rd, 2002, 11:37 PM	#6
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	I use 2000 and XP. I like XP better, the help is better. The "Speak" tools are a step in the right direction. What missing though is a tool to code or create a function by example! You still need to know way too much syntax! With PC's having more power and speed than mainframes of just a few years ago, I am still disappointed in the lack of artificial intelligence engines in applications. When XP finds an error in your function the auto-correct in XP is about the same as 2000, both are primitive. More can be done to improve on this now. When coding tools like "C" programing almost killed "Basic" programing, faster more powerfull PC's brought "Basic" back to life. Now PC's are even more powerfull and VBA code that was dirty, slow and full of primitive routines in 97, can run in 2000 and XP so fast, you don't need to refine your code along the "computer economics" methods essential just a few years ago. So the benefits of XP now is in part due to the faster more powerfull PC's. XP is great but it could be better with todays and tomorrows PC's. I would also like to see a function library that works like "Spell-Check." That is, we should be able to add functions like we add words to a dictionary rather than the convoluted steps needed now. A more open approach to Excel code would improve the product, rather than the closed-fisted MS way. The way MS did the public with DOS was a crime. We waited for each release, only to find few new tools that could have been released years earlier. The whole scam for profit and R&D recovery set the software application and PC development back about ten years. I feel cheated and rightly so as I know what it cost the consumer. With Excel being the best product out, it is good, but it could be better. I see a lot of how DOS was marketed in the Excel releases and that saddens me. JSW P.S. Almost forgot the most important missing item, a "packager." I would like to be able to put Excel developed applications on CD's and distribute them to users who do not have Excel or the current version. Like the "run-time" builders for database applications, come on MS already! [ This Message was edited by: Joe Was on 2002-05-03 23:14 ] [ This Message was edited by: Joe Was on 2002-05-14 06:16 ]

May 4th, 2002, 10:44 AM	#8
cc_kmoore New Member Join Date: May 2002 Location: LA, CA, USA Posts: 2	Thanks for the replies. No color in headers/footers and graphics only if using Office XP. This is what I told colleagues, but it just didn't seem possible that full text formatting of headers/footers is still not available. Excellent assistance with my first trial post. I'll be back ! K Moore