Jul 23 2021 08:26 AM
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
Jul 24 2021 08:29 AM
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.