I prepare some accounting reports in Microsoft excel. I add header and footer to those excel sheet. I want to add a line under the header and above the footer. Can someone tell me how it can be done?
Thanks.
I can explain you a way to add a line to header/footer in Microsoft excel. However, there is no option has been provided to add a line to header/footer in excel.
Anyway, follow this method; you will be able to do this.
I will take an excel sheet for an example.
First click on the print preview and click on the page setup. Then click on the header/footer tab and again click on the custom header.
Then type the header that you want in any section. I will type as “Purchase report” and click enter.
Now the cursor will blink in the below line. Then keep typing the key dash (_) while holding the shift key.
Then click ok twice and check in the print preview a line will be displayed under the header.
Go to Header/Footer Option as you have set up your Header and Footer. For header put your cursor at left of your existing line or word in header box. Write your required new sentence. Then use enter; the new sentence will remain above the old one.
In the same way go to Footer box. Put cursor at the end-right of the existing footer word or sentence. Use enter and write your required new sentence.
There are two approaches to create a header or footer for a printouts,
The Page Layout View
Press the TAB key to move to the center section of the Header.
Page Setup Dialog
The dialog shows separate text boxes and previews for the header and footer. Your current header shows in the Header preview. In the Header text box there is a comma between the text for each section. The arrow at the end of the box opens a drop list of commonly used headers.
Hope this helps.
