Is it possible to change the font colour in the Header and Footer in an Excel spreadsheet? I can see options to change the font style, size, embolden, italicise etc., but no mention of font colour.One of my students has posed this question, so my credibiity hangs on this (not!).Mike
I am using Office 2003 and the answer unfortunately is no!
But you can use an image as a header, so maybe you can create your required text in Paint, save it as an image, and then use it as the header?
You could try the MrExcel.com website and do a search on the message board.
Another alternative would be to put the coloured header on the first (or last) row, either as coloured text or using the draw facility and adjusting the row height as necessary.Next leave enough space as required before the details of the spreadsheet(checking the layout in preview).Finally, Before printing, reduce the top (or bottom) margin to 0.5cm and print.I dare say some printers may not accept the margin at 0.5cm but mine (Lexmark) didn't object.
Thanks folks. I know it's not really resolved yet, but I will try the Mr Excel site or, failing that the excellent suggestions that you have made.Mike
This thread is now locked and can not be replied to.
Sea of Thieves Review
Dell Canvas review: the cheap Wacom Cintiq alternative
How to use iMovie for Mac, tips and more
Comment filmer l’écran d’un iPhone ?
© Copyright 2018 IDG UK. All Rights Reserved.