Excel _ How I can insert a horizontal line in the header and footer

Question

Hello,

In Excel, I would like to insert a horizontal line in the Header and Footer.

Thanks in advance :)

Kim

Answer 1

Hello Kim,

We have looked into your case and found out that the option to add horizontal line in the headers and footers is not available yet. What we can do now is to add, change and edit headers and footers.

You may share all of your suggestions through this link. This page is where our development team get ideas in order to improve our services through the upcoming updates.

As always, your inputs are highly appreciated.

If you want to be told that what you want to do can't be done, ask Microsoft!

Anyway, there are three ways I found, and a forth way I found doesn't work only because word is not compatible with excel?!?!?!

Method 1, multiple dashes ---------------------------- Downside is that it is clearly dashes...

Method 2, multiple underscores, downside is that it has to be at the bottom of a line, which pushes your text lower.

Method 3, tricky but powerful, make your footer, go to print preview, gauge how far up/down you want your line.  Then insert>shapes and pick the line, draw it to your best ability and then go into your print preview again and see how close you are, repeat as needed.  The requires a good eye and some time, but you can make any line you want!

(unavailable) method 4, make the line in a microsoft word header and copy/paste it into your header.  Unfortunately Word does not seem to be compatible with excel-in a way it should be!

Oh, and speaking of word, possible option 5, annoying as heck, paste your excel data into a word document as a table.  You can link the table to the original spreadsheet so it can update.  Or do the same in powerpoint.

So microsoft tech support, the above is what happens when you try to find solutions rather than duck out of work.

Answer 2

Courage, I think you just hit on another way!

Header>Custom Header>insert image.

Just screenshot a line and paste the image in.

Answer 3

I think what the Kim wants is the one that looks like this:

Normally, the horizontal line, that option is not available in Excel the way how we can do it in Word. But you can do what Aaron-Baker has suggested. I have tried to replicate it in my Excel and we cannot insert a horizontal line in Excel. These photos below show the action we can do in Headers and footers

.

We cant achieve whats there in Word, but yes, you can use alternatives.

Answer 4

Thank you for all yours replies,

That's the first time I posted a question and I'm so glad that I've received all the good answers.

I've follow Courage advise and add a snapshot «line» picture and it works perfectly.

Thanks !!!!!

Kim

Answer 5

Hello Kim,

We have looked into your case and found out that the option to add horizontal line in the headers and footers is not available yet. What we can do now is to add, change and edit headers and footers.

You may share all of your suggestions through this link. This page is where our development team get ideas in order to improve our services through the upcoming updates.

As always, your inputs are highly appreciated.