Excel 365 Footers - Adding a horizontal line

Copper Contributor

Hi everyone

Is there any way of adding a horizontal line above the text within a footer in excel 365? I'm trying to add company information (address, company reg etc) but with a line above to separate this out from the excel data.

Is there a way of doing this - ? i've tried __________ within the footer but this uses up the maximum amount of character allowed. I've tried creating a picture but this isn't great either.

 

If not, can anyone suggest how can i differenciate/separate the footer from the data above?

Any help would be appreciated.

Thanks

J

1 Reply

@julesf 

 

Just hope it's not Excel for the web.

Please always state at least Excel version and operating system.

Above all, it helps you to get a quick and precise proposal for a solution.

 

If you want to underline the text of the footer or header,

then select Layout > Header Footer > the icon with the capital A (font) > underline in the side view.

 

A line beyond the text is only possible if you put a frame around the cells concerned.

 

or with VBA:

With ActiveSheet.PageSetup

.LeftFooter = "" & Chr (10) & "your own name"

.CenterFooter = "& KFF0000 ________________________ & K01 + 000" & Chr (10) & "created on: & D at & T"

.RightFooter = "" & Chr (10) & "Page & P of & N"

End With

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.