Forum Discussion

julesf's avatar
julesf
Copper Contributor
Jul 23, 2021

Excel 365 Footers - Adding a horizontal line

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

excel
office 365

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 24, 2021

    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.

     

Resources