In MS excel header and footer option is used to display the repeated graphics or text on the top or button of each pages in a document. You can insert a picture (company logo or other related picture) in the bottom or top margin of each page. For reference, you can add the data, time and path for where you saved excel file on your computer or on any network server. Both the header and the footer are displayed in print layout view and save your time to enter the same items in pages again and again. You can use the same header and footer throughout a document or change the header and footer for part of the document.
You can leave the header or footer for the first page and can also use different headers and footers on odd and even pages or for part of a document.
To apply header or footer, follow these steps.
Select "Header and Footer" from View menu, "Header and Footer" Floating Toolbar will appear. The header and footer sections of document are also activated.
Now under Header/Footer tab, click on Custom Footer button then select left section.
To insert the picture, click on Picture icon (the 2nd icon from the right side) to select the company logo that you want to add.
Select other options if required, for example you can add date, time file name and file path also.
Now click Ok button to finish the process.
No comments:
Post a Comment