Excel 365 Footers - Adding a horizontal line

%3CLINGO-SUB%20id%3D%22lingo-sub-2580241%22%20slang%3D%22en-US%22%3EExcel%20365%20Footers%20-%20Adding%20a%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580241%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20of%20adding%20a%20horizontal%20line%20above%20the%20text%20within%20a%20footer%20in%20excel%20365%3F%20I'm%20trying%20to%20add%20company%20information%20(address%2C%20company%20reg%20etc)%20but%20with%20a%20line%20above%20to%20separate%20this%20out%20from%20the%20excel%20data.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20of%20doing%20this%20-%20%3F%20i've%20tried%20__________%20within%20the%20footer%20but%20this%20uses%20up%20the%20maximum%20amount%20of%20character%20allowed.%20I've%20tried%20creating%20a%20picture%20but%20this%20isn't%20great%20either.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20not%2C%20can%20anyone%20suggest%20how%20can%20i%20differenciate%2Fseparate%20the%20footer%20from%20the%20data%20above%3F%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJ%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2580241%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2582944%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20Footers%20-%20Adding%20a%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2582944%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111121%22%20target%3D%22_blank%22%3E%40julesf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EJust%20hope%20it's%20not%20Excel%20for%20the%20web.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EPlease%20always%20state%20at%20least%20Excel%20version%20and%20operating%20system.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAbove%20all%2C%20it%20helps%20you%20to%20get%20a%20quick%20and%20precise%20proposal%20for%20a%20solution.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20you%20want%20to%20underline%20the%20text%20of%20the%20footer%20or%20header%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Ethen%20select%20Layout%20%26gt%3B%20Header%20Footer%20%26gt%3B%20the%20icon%20with%20the%20capital%20A%20(font)%20%26gt%3B%20underline%20in%20the%20side%20view.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EA%20line%20beyond%20the%20text%20is%20only%20possible%20if%20you%20put%20a%20frame%20around%20the%20cells%20concerned.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eor%20with%20VBA%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWith%20ActiveSheet.PageSetup%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E.LeftFooter%20%3D%20%22%22%20%26amp%3B%20Chr%20(10)%20%26amp%3B%20%22your%20own%20name%22%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E.CenterFooter%20%3D%20%22%26amp%3B%20KFF0000%20________________________%20%26amp%3B%20K01%20%2B%20000%22%20%26amp%3B%20Chr%20(10)%20%26amp%3B%20%22created%20on%3A%20%26amp%3B%20D%20at%20%26amp%3B%20T%22%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E.RightFooter%20%3D%20%22%22%20%26amp%3B%20Chr%20(10)%20%26amp%3B%20%22Page%20%26amp%3B%20P%20of%20%26amp%3B%20N%22%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EEnd%20With%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.