Excel 2007 Header Doesn't Print


C

climber

I have a number of workbooks created in Excel 2003 which displayed and
printed the headers and footers properly. When I open some of them in Excel
2007, to which we just upgraded, they don't display or print. Yet, when I
set the view to page layout, the header/footer appears as I scroll across
them, and I see them in Page Setup. Other workbooks display and print fine.
What might be my problem?
 
Ad

Advertisements

C

climber

Discovered the cause and solution. A second clue arose where, as I attempted
to type in the header, nothing would appear on screen or paper, i.e., act
like invisible ink. For whatever reason, the font color was non-existent
even though the color box said automatic. Solution is to bring up the header
in Page Setup, edit the custom header/footer, click on the font button, click
on the font color box, select automatic or color wanted, click the ok button
in the font window and the header/footer window. note, to simply click on
the font button then OK was not enough.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top