Creating Headers in Excel

  • Thread starter Thread starter adrian007uk
  • Start date Start date
A

adrian007uk

Hi i am in need of some help. I am creating a number of templates in both
Word and Excel. I have no trouble creating the header i want in Word. I
have a logo on the left, the document title in the middle and the documents
reference number on the right. I have then placed an underline (i think it's
called a 'tether') right across the bottom of the header.

The problem is creating the same in excel. I can put the logo on the left,
the title in the centre and the reference number on the right (all in the
header). However, i can not place an underline across all three sections of
the header in Excel. Can anybody please help?
 
Adrian,

One way would be to take the first row of your print area and fill it with a
color, reduce the row height until the row looks like a line, then use the
Sheet tab of the Page Setup to set that row to repeat at the top of all
pages.

HTH,
Bernie
MS Excel MVP
 

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

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
Header rows 4
Move logo from word document to excel header 3
Excel Header - Auto Format troubles 1
Excel 2007 Header Doesn't Print 1
Headers in Excel 1
printing a header in Excel 2
Including document property values in Excel headers 2

Back
Top