Forum Discussion
Excel 365 Footers - Adding a horizontal line
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.