5 Steps to Customize your Header and Footer

image_pdf

Customization of Header and Footer is very useful to provide important information while printing.You can create a footer that has page numbers, the date and time, and the name of your file. Headers and footers are not displayed on the worksheet in Normal view — they are only displayed in Page Layout view and on the printed pages. Read more: How to add Header and Footer in Excel?

To insert Page number, Date and Time and your file name etc. in header or footer, execute the following steps.

On the Insert tab, in the Text group, click Header & Footer.

insert header and footer

1) To add a Page Number, Double-click the text box. On the Design tab, in the Header and Footer Elements group, click page number. Select any other cell of worksheet to display Page Number.

Note: There should be moe than one page filled to show page Number

Page Number

Result: Page Number is displayed in Footer.

Result

2) Display page Number with Total No of Pages. For Example, click on Page Number than write " of " and again click on Number of Pages in selected Footer. Select any other cell of worksheet to display it.

Note: There should be moe than one page filled to show page Number

No of pages

3) To add a Current Date, click current date. Select any other cell of worksheet to display date. Same way we can insert Current Time.

Date

4) If you are printing many pages, then it will be easy if the printed page has filename and sheetname on it. Customize Fite name and sheet name as shown below.

file name-sheet name

Result: File Name and active sheet name will be displayed in page view layout and on the printed pages. Same way FIle path can be included in header and Footer

file name-sheet name result

5) You may want to insert logo of your company or any picture in Header.To add a Picture, click picture.

Insert Picture in Header & Footer

Note: - You can format the picture for example height, weight and position with the help of Design tab, in the Header and Footer Elements group, click format picture. First select the picture in header or footer and then format picture appear.

 

1,994 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>