Customize Header/Footer in Excel 2010

We have quite cuztomized headers and footers in our quality documents in Word and I'm trying to replicate the header/footer in Excel and wanted your opinion if this is:
a) achievable and
b) if 'yes', how and if 'no', what workaround/options do I have?

I have attached a Word file with the current header/footer.

Thank you for your help.
template_header_footer.docx
WTC_ServicesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
you probably need to redesign the "header" as part of the cells in Excel worksheet, and set the Print Titles after that.

here's the trick:

Repeat specific rows or columns on every printed page
https://support.office.com/en-us/article/Repeat-specific-rows-or-columns-on-every-printed-page-0d6dac43-7ee7-4f34-8b08-ffcc8b022409
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
WTC_ServicesAuthor Commented:
Hi Ryan,

Sorry for my delay in responding to your solution.

Your solution works well for the header but it doesn't address the issue I have with the footer. I don't think there is a proper issue for the footer issue. I cannot replicate the exact same footer in order to use it as a template, with having to re-design it.

Thank you very much.
0
Ryan ChongCommented:
for the footer, you probably can use the Custom Footer tool available in Excel.

custom footer
But as you can see, it's quite limited compare to the options we have for the header. To have a "custom made" footer, we probably can create the artwork and then saved as a picture, and then upload accordingly, IF we can't customize the footer as what we can for the header.
0
WTC_ServicesAuthor Commented:
I have come to terms with Excel's limitations with header and footer. This will include re-design of header and footer.
0
WTC_ServicesAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for WTC_Services's comment #a41053124

for the following reason:

The solution is to keep using the basic and limited header and footer options of Excel and have to redesign my header/footer instead. In other words, I cannot use complex header/footer in Excel. I was hoping for a more whiz-bang solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.